I have a SELECT statement that uses a phrase with ('s) and this (&). But it doesn't work.
"SELECT * from $table_name WHERE department LIKE
'%Kid's & Parents%' AND '%Accessories%')";
What this is suppose to display is, the main category of
Kid's & Parents, found result(s) for Accessories, then my
next work will be Kid's & Parents next subcategory,
and so on, until I have completed my pages.
The problem is I get the error:
You have an error in your SQL syntax.
Check the manual that corresponds to
your MySQL server version for the right syntax...
So I am assuming there is something wrong with the apostrophe and the ampersand.
What do I use?
charles256
