"any" for a value

[Anon]

This is my query
$query2 = "select * from Login, UserInfo where Login.Ref = UserInfo.Ref AND Login.Sex = \"$status2\" AND Login.Psex = \"$status1\" AND UserInfo.Age =< \"$age1\" and UserInfo.Age => \"$age2\" and UserInfo.State = \"$state\" and UserInfo.Country = \"$country\" limit $offset,$limit";

Now if you look state, country, and age, They are all a required variable from the form. But they can have a value of "any".
I have try to set state = "";
if ($state == "any")
{
$state = "";
}
That does not work..
Do you have any ideas?>
Thanks
Chris

[leatherback]

How about building the query dependent on the input:

if ($state == "any"){
$query2 .= "" } else {
$query2 .= " and UserInfo.State = $state "}

(Coding is messy, but you get the idea?)

J.

[Anon]

I could do that, but I am querying 3 items.
Also my query statement would allready be searching for state.

if query = "" mysql will not search grab all the data in those fields.

[Anon]

Please let me knwo if there is another way, that way J Ferwerda does not work.
Thank you though..

CHris

[leatherback]

Well, I am using it in my boxbuild routines. There it works.

This is a snippet of the exact statement I am using. I left part of the codes out and replaced them with *** for clarity (Which works in the site I am constructing. Sorry not online yet):

$sql_query = "Select from ";

If ($AllSub==1) {
$SubQ = "";
} else {
$SubQ = " and subject.id = '$Sub' " ;
}

---

$Input_query = " where " ." $SubQ " ." $ThemQ " ." $CountQ " ." AND ";

$sql_query .= $Input_query ;

$Results = mysql_query($sql_query)

[mistcat]

J Ferwerda is basically correct, the best way to do this is with a conditional, his sql just needs to be changed a bit (grin)

if ($state != "any"){
$query2 .= " and UserInfo.State = '$state' ";
}

when you select for ANY state, you don't make it a requirement of the search that it be = to anything. You know what I mean?

• nate