Im trying get in an array all data1 that found search1 in the table dbtable1:
$q = mysql_query("SELECT * FROM dbtable1 WHERE INSTR(data1, 'search1')") ;
I also tried with:
$q = mysql_query("SELECT * FROM dbtable1 WHERE data1 LIKE '%search1%'");
but i dont get results and im sure that some data1 in my db have the string that im searching in search1.
maybe i have an error int he syntax.
thanks.
Hi,
We are a skilled development team and we are working in web development for the last four years we can complete your task in efficient time and cost please fell free to contact us
Thanks
moonwebtech
Sir, I can do this project .Tell me more about your project.
My goal is to provide best service for my clients in minimum possible amount.
I will accept projects only when i'm 100% sure.
Thanks! :)
Dear Employer,
I am ready to work on your required task and can also give 100% satisfaction.
Looking forward to an opportunity to work with you.
Warm Regards: WebMediaPak
Greetings
Ready to fix the issue with blog and INSTR/LIKE . Please share the link of the site and let em know when can we discuss
I am expert in php and insure you to provide the work as you are looking for .
Waiting for your Response.
Kind Regards
Hi,
I'm a developer having experience in MySQL. I can provide you with high standard work. I'm ready to start work right now. Please PM me for more details.
Thank You
With my 7 years of experience in Web development including PHP, Mysql, HTML, JS, AJAX, JQUERY, CSS, Drupal, Joomla, Magento, Wordpress, etc, I can give you the quality output with sincere effort. I am looking forward to work with you. Thank you.
I have 7 years of experience troubleshooting MySQL problems like this one. I will send you a script to include just before your call to mysql_query to collect information about the database and the connection. If the data collected is insufficient to pinpoint the cause of the problem, further data collection may be needed. I will explain why INSTR and LIKE do not produce the expected result and what modifications to the SELECT statement are possible to obtain the expected result.