[SOLVED] Using an if statement within a mysql_query

[forumnz]

Is this just done by ending the query mid way without ending with a ) and then executing the if statement then closing with )?

 

Thanks,

Sam.

[corillo181]

why would you want to do something like that?

 

how about put your testing if inside a string?

 

$mystring = ($this == $that) ?'hello': ' no hello';

 

query("select $mystring from ...")

[p2grace]

I agree with corillo181, it would bad practice to throw an if statement inside of a query.  Much better to create an if statement to create a string variable, then put that string variable into the mysql statement.