php mysql empty,可能让PHP MYSQL查询忽略WHERE子句中的空变量？

Not sure how I can do this. Basically I have variables that are populated with a combobox and then passed on to form the filters for a MQSQL query via the where clause. What I need to do is allow the combo box to be left empty by the user and then have that variable ignored in the where clause. Is this possible?

i.e., from this code. Assume that the combobox that populates $value1 is left empty, is there any way to have this ignored and only the 2nd filter applied.

$query = "SELECT * FROM moth_sightings WHERE user_id = '$username' AND location = '$value1' AND english_name = $value2 ";

$result = mysql_query($query) or die(mysql_error());

$r = mysql_numrows($result);

Thanks for any help.

C

解决方案

Use

$where = "WHERE user_id = '$username'";

if(!empty($value1)){

$where .= "and location = '$value1'";

}

if(!empty($value2 )){

$where .= "and english_name= '$value2 '";

}

$query = "SELECT * FROM moth_sightings $where";

$result = mysql_query($query) or die(mysql_error());

$r = mysql_numrows($result);