This probably a dummy question, but I have a hard time searching a database with apostrophe in search field.
Here is my query:
$r = dbQuery("SELECT products_id, name, description FROM products WHERE description LIKE '%$keyword%' ORDER BY name");
$keyword could have something like "Baby's". I got error when the search field entered has " ' ". Can anyone help me? Thanks.
