Syntax Question

[Anon]

I am using MySQL to store classifieds by category and everything is working great except when I query on a category that is listed as "Antiques & Collectibles" it only returns the 'Antiques' and not the & Collectibles what is a way around this for it to recognize the whole string I've tried " & Collectibles" and a couple of other things to no avail What's the proper syntax for this kind of query?

[vsego]

Can you give us a code snippet and part of what it returns (the part of proper output and the part that's not ok)?

[Anon]

Well, in the database one of the categories is Antiques & Collectibles. When I run the query:

SELECT * FROM $table_name WHERE category = $category;

What it returns is Antiques with no entries because the entries are 'Antiques & Collectibles' I believe it's becaus of the & in the string because the spaces don't affect the outcome.

Does that help?

[vsego]

Are you sure? It seems like you're missing quots around $category:

SELECT * FROM $table_name WHERE category = '$category';

[Anon]

Positive, doesn't matter if the quotes are there or not. It returns fine up in the address bad it sayd...category=home%20&%20Garden but the echo says "Home" and it returns 0... Any other ideas?

[vsego]

Can you post (or email me to [e-mail]) the whole script?