[SOLVED] IF inside query

[tj71587]

I've been working jsp lately and there is a tag that you can place inside the query for an if statement.  Obviously there is no tag in php, but is there any way to place an if statement inside the query?

[Aureole]

Not that I know of I think you have to do it like...

 

<?php
if(condition 1) {
    // Query 1
}
elseif(condition 2) {
    // Query 2
}
// etc...
?>

[tj71587]

Yeah thanks, thats what I have been using.  I was thinking in terms of

SELECT *
FROM table
WHERE 1=1
if(conditon)
{
AND ....
}
if(conditon)
{
AND ....
}
if(conditon)
{
AND ....
}

 

But I doubt thats an option, thanks though.

[pocobueno1388]

You can keep adding to the query like this:

 

<?php 

$query = "SELECT * FROM tablem WHERE 1=1";

if(conditon){
  $query .= " AND blah='$blah'"
}

if(conditon){
   $query .= " AND whatever='$whatever'"
}

?>

 

Is that what your trying to do?

[tj71587]

Exactly it, thanks so much.