if statement help

[jaZon]

I'm pulling a lot of stuff out of a db and I plan on making if statements for every query possible. The query will include brand, type, and subtype. For this to work I have to have all possible if statements, so I have to have one that has nothing set, one that has brand set and everything else not set, one where brand and type are set while subtype isn't set and one where they're all set.

I think I can get the one where nothing is set and the one where everything is set, but the rest I'm clueless. How do you say that one thing is set while others aren't?

[kamy99]

if (isset($variablename) and (!isset($var2)) and (!isset($var2)))
{
....
}

HTH

[Rodders]

Is this working like a search facility that a user fills out ? As in the user fills out a form with everything they want to search on and your PHP will build the SQL based on that. So that, if they don't enter anything in a particular field you want all of that, but if they do enter something you want to limit to that (or maybe use wildcards).

Here's what I do:

$where_clause = " WHERE 1 = 1";

if (isset($var1)) {
$where_clause .= " AND field1 = '$var1'";
}

if (isset($var2)) {
$where_clause .= " AND field2 = '$var2'";
}

etc.etc.

$sql = "SELECT * from table" . $where_clause;

[coditoergosum]

if (isset($brand) && !isset($type) && !isset($subtype) {
// do stuff 
}
elseif (isset($brand) && isset($type) && !isset($subtype) {
// do other stuff 
}
elseiff (isset($brand) && isset(&type) && isset($subtype) {
// do this other stuff 
} 

// etc... 

You can use && and || in conditional statements where && equals 'and', and || equals 'or'.