[RESOLVED] If statement in query

[tommmmm]

Is it possible to run and if statement inside a query. Something like

$query = "SELECT * FROM x WHERE y=z if(isset($var)){AND p = '$var'}";

Thanks in advance for the help.

[tsinka]

Are you talking about a php variable ? In that case you need to do something like:

 $andPart = isset($var) ? " AND p='".$var."'" : "";
 $query = "SELECT * FROM x WHERE y=z".$andPart; 

Thomas

[tommmmm]

Thanks that worked perfectly! Much appreciated.