multiple varibales in a select statement

[nozom]

I want to pass 3 varibles from a form to a MySQL select statement.

example:

the user wants to search by name, city and country. or just name, or just country or just city etc.

with me??

I could have a different select statement for every possibility but this is rather long and annoying.

i want to be able to have

"SELECT * FROM my_table WHERE name='$name', city='$city', country='$country'

if one or more of the 3 hasn't been chosen in the form then it is ignored? Is this possible to do??

Hope that all made sense,
hugh

[pyfsapple]

Instead of using many combinations of if-else, you may use LIKE in mysql statement.

For example:

if($name == "")  //not by name
    $name="%";
if($city == "")  //not by city
    $city= "%";
if($country=="")  //not by country
    $country="%";

$sql_statement = "SELECT * FROM my_table WHERE name LIKE '$name' AND city LIKE '$city' AND country LIKE '$country'";
......

If none of the three is entered, all will be selected!

[nozom]

brilliant, brilliant.

thanks very much, exactly what i was looking for. I'm amazed you managed to get what i was trying to say ;-)

Cheers,
Hugh

[pyfsapple]

Ha~

No thanks~