Multiple Search Criteria

[Anon]

This thread is in relation to my post earlier. I want to rephrase it again

How should I formulate my SQL statement where the user has more than 1 search criteria? Because it is a search page, I will not know if the user is search by name or age or gender or in any combination.

My earlier posting was about a people search directory page. I have problem creating the where condition in the SQL statement.

Q2) Is there 'endif' in PHP? Or just if .. elseif ...end

Thank you

This thread is in relation to my post earlier. I just want to rephrase it again

[Anon]

You just have 10 if staments!

if ($name != "") {
$sql .= " Name LIKE '%$name%' ";
}

if ($age != "") {
$sql .= " Age LIKE '%age%' ";
}

// etc...

You're gonna have a slight problem with a commas, but that's not too hard to solve so I'll leave it to you.

Q2) Is there 'endif' in PHP? Or just if .. elseif ...end

What do you mean? 'endif' is the same as 'end'.

How are these 2 different:

if (condition) {
} // this is the same as 'endif'

if (condition) {
} elseif (condition) {
} // this is also 'endif'

Diego