[RESOLVED] Confused about this query

[j0s3]

i have this query

"SELECT * FROM mytable WHERE quality=$quality";

$quality is set in a dropdown menu, to which i've just added the option "ANY"

so i need to be able to run the query and show everyting selected of ANY quality

but of course if i do
"SELECT * FROM mytable WHERE quality=any";

it will just error

is there a way around this?

thanks
jg

[MitchEvans]

Could try:

WHERE $quality='any';

[liquorvicar]

Why don't you build the query a bit at a time?

$sql = "SELECT * FROM mytable";

if ($quality!='any') {
    $sql.= " WHERE quality='$quality'";
}

// execute $sql

[j0s3]

liquorvicar - that works!

thanks so much!