I have a database with 6 rows, I need to search it using one or more variables.
What would be the easiest way to do this.
Something like this:
$query = "SELECT xxx from TABLE where field1='" . $variable1 . "' OR field1='" . $variable2 . "'";
You can add as many as you need.
-- Jason
just a sidenote: you can shorten up that query by using IN
$query = "SELECT xxx from TABLE where field1 IN ('$variable1', '$variable2')";
Will search where field1 equals either $variabl1 OR $variable2
Cgraz
