Search Form

[The_PHP_Newb]

This is my 1st post, forgive me if it's a repeat, I searched and couldn't find my solution.. I have a search form w/ a dropdown and need the 1st selection to be "all". Example:

<select size="1" name="state">
<OPTGROUP LABEL="United States">
<option value='''>All States</option>
<option value="AK">Alaska</option>
<option value="AL">Alabama</option>
<option value="AR">Arkansas</option>

<option value='''>All States</option> is the option in question.

My query on the results page looks like this:

$results=mysql_query("select * from profiles where state = '$state'");

The option set as above returns nothing. I tried <option>All States</option> but of course that defaults the value to the tag name (All States) itself.

Can someone show me how I can set this up and the query will produce everything vs. nothing! LOL. Thanks much! Great board you have here (for newbs like me).

[cgraz]

$query = "SELECT * FROM profiles";

if (($_POST['state']) && ($_POST['state'] != "")) {
   $query .= " WHERE state='" . $_POST['state'] . "'";
}

$result = mysql_query($query) or die(mysql_error());

Cgraz