mySQL Query

[Anon]

Help required coding a multiple query whereby there are four search criteria. The first two are mandatory (thats easy !), but how do you then extend the query to a further two numeric variables that may or may not be used and which are quoted as "less than" a particular number.

So here is an example of a full search criteria for a my SQL database :

Find all records that are -
1- green and
2- plastic and height is
3- <10 and width is less than
4- <2000

[Anon]

Its a relatively simple thing to do...

$sql = "SELECT * FROM table WHERE field1 = 'green' AND field2 = 'plastic'";

If (IsSet($height)) {
$sql .= " AND height < ". $height
}

If (IsSet($width)) {
$sql .= " AND width < ". $width
}

Then execute your sql and whala!

-Shea