one table, multiple sql query

[jimmylegs]

i have a form with three select boxes that will go to an action page.

bit stuck on the mysql on the php action page. only have one table (test). i need it so that a user can search for either one or two or all three criteria.

i am storing the query in a variable;

$sql = "select fname, lname, city, id_number from test";

have seen that you can append info to the query like the following;

if ($cuisine != "") {
$sql .= " and fname = '$fname'";
};
if ($postcode != "") {
$sql .= " and postcode = '$postcode'";
};

but i can't get it to work. any help would be great!!

[jimmylegs]

i have got this so far. however, it finds all records for each select box that is selected, rather than just the records that meet all the conditions.

$sql = "select fname, lname, city, postcode, email from pmp1 where city = '$city' or lname ='$lname' or interest ='$interest'";

i'm sure this is obvious but i have been staring at it for ages!