[Resolved] Can you query with a string?

[szym9341]

I have the following query. In the varchar column called 'web' I stored the word "Yes" or "No" for each style_id. Now, I would like to add the search criteria ... (AND web = Yes) underneath (AND gender_id = $gender_id), but I can't get it to work. Did I mess up and need to redo a ton of pages, or can I somehow query with the varchar web column?? Any help will be greatly appreciated.

$getstyles = @mysql_query("SELECT * FROM styles
                             WHERE subtype_id = $subtype_id
                             AND gender_id = $gender_id");

[AQHost]

Hi,

Does this work? If not, what error message do you get?

$getstyles = @mysql_query("SELECT * FROM styles WHERE subtype_id = '$subtype_id' AND gender_id = '$gender_id' AND web='Yes'");

Best wishes,
Simon.

[szym9341]

yes, it works just fine... thanks so much.