Hi,
systax summary:
$insert = "do's";
$sqlquery = "select * from table where
title LIKE '%$insert%';";
Problem:
I have tried ereg_replace as well as str_replace, so does addslashes and stripslashes. But I cannot send the query to the database.
Original systax Error msg:
SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression 'paper.category='Full' and paper.status='accepted' and paper.paperid=paperauthor.paperid and paper.status=paperauthor.status and paperauthor.authorid=author.authorid and paper.title like %do\'s%;'.,
Does any one has a solution for this??
Thank you very much.
GK