My query is working fine but i want refine this query, for example some pass a string like: silver's, gold's etc then how it will work? it don't work problem for characters like '," etc
I find it simpler to do this:
$query = "'%";
$query .= $_GET["srchStr"];
$query .= "%'"
(wrap the search string first)
Then...
"select product.productid from product where product.product_title like $query"
(the $query variable includes the single quotes needed)