Lost in elseif land

[Anon]

Hello

I finally succeded in creating separate sql queries for the options in a drop down box.

What I\'m trying to do now is: if there are no results in the mySQL databse I would like to echo a statement that says just that, \"no results for your query\" or something.

The code in question that I\'m working with looks like below. There are more options but it\'s all the same thing.

Thanks for your help.
...................................

if ($test == \"2\")
{
$sql = \"select zone, DATE_LAST_VISITED, ZONE_DESCRIPTION, CURRENT_STATUS from WESTERN_WASHINGTON where date_last_visited >= DATE_SUB(CURRENT_DATE,INTERVAL 2 day)\";
}

elseif ($test == \"4\")
{
$sql = \"select zone, DATE_LAST_VISITED, ZONE_DESCRIPTION, CURRENT_STATUS from WESTERN_WASHINGTON where date_last_visited >= DATE_SUB(CURRENT_DATE,INTERVAL 4 day)\";
}

[Anon]

If you just want to see if there were any results and output accordingly, try this:

if(mysql_num_rows($sql)) {

results were found

do whatever you want to do

}
else {

no results were found

echo"no results for your query";
}

I hope that helps and answers your question.