Any for a Mysql Value

[Anon]

Hello I was wondering if i could get some help.
Here is my Question.

I have this for code
This is just a peice of the code

if ($state == "any") {$state = "*";}

    if ($age == "any")			{$age1 = "*";			$age2 = "*";}
					if ($age == "22")			{$age1 = "18";				$age2 = "22";}

I am doing a search for age and state. If the age does not matter... what does age need to =
and if state does not matter what the user picks.. what does state need to be for a value.
Thank you
Chris Calzaretta

[Anon]

Do something like this:

if (char is NOT '*') {
add WHERE clause to the query
} // else do nothing - no need of WHERE clause

Diego