Apostrophes causing MySQL error??

PHPAnx

When I search my database using an "apostrophe" in the search field it returns this error:

Warning: Supplied argument is not a valid MySQL result resource in /public_html/results.php on line 52
SQL : SELECT DISTINCT toursArtist,toursDate,toursCity,toursState,toursVenue FROM tours WHERE toursArtist LIKE '%Keb' Mo'%' ORDER BY toursDate LIMIT 0, 31

Error : You have an error in your SQL syntax near 'Mo'%' ORDER BY toursDate LIMIT 0, 31' at line 1

Warning: Supplied argument is not a valid MySQL result resource in /public_html/results.php on line 58

How can I change my code to allow one to search with apostrophes? Also, even if I search without one, but the row has one in it, I still get this error??!!!

I have 50k records in the DB so I can't redo it, it must be fixed via the search.

Thanks!

PHPAnx

I sort of figured it out...

Changed original code:

$sql="SELECT DISTINCT toursArtist,toursDate,toursCity,toursState,toursVenue FROM tours WHERE $show LIKE '%$search%' ORDER BY toursDate LIMIT $offset, $sqllimit";

----to-----

$sql="SELECT DISTINCT toursArtist,toursDate,toursCity,toursState,toursVenue FROM tours WHERE $show LIKE ('".addslashes($search)."') ORDER BY toursDate LIMIT $offset, $sqllimit";

The problem now is that I cannot get my "%" to work at all??!!! How do I do this and still maintain the use of my % keyword search??

Thanks

Wien

you're so near, we should not help u 😉

try :

$sql="SELECT DISTINCT toursArtist,toursDate,toursCity,toursState,toursVe
nue FROM tours WHERE $show LIKE '%" . addslashes($search) . "%' ORDER BY toursDate LIMIT $offset, $sqllimit";

PHPAnx

Thanks Wien, after knocking my head around last night I finally did figure it out. Would have never guessed such a solution would be so simple in the end!