WHERE statement in MYSQL

[ianwattb]

ive been trying to do a where statement to find a specific piece of text in a row but i can't get it to work for some reason.

mysql_query("SELECT * FROM Info WHERE Category = Software",$db);

I've tried numeral different ways of doing this even this one below which i think is the main way of writing this

mysql_query("SELECT * FROM Info WHERE Category = 'Software'",$db);

"Category" is the name of the row inside the database and "Software" is the value i wish it to bring up.

Because of the code am using i have an if statement set up to retun echo if it cant find any results and all i get is the set echo back saying it can't find any records even though i have more then one value matching "Software" in the database.

Any help on this would be most helpful please.

[ianwattb]

i got it to work it turns out that mysql doesnt like you using Uppercase when referring to a row name and somefing in a row. Thanks for help anyway.