can anyone figure out why the following code works fine when both select
variables = "ALL" and also when only 1 of the 2 ="ALL" but NOT when BOTH
select variables equal something other than "ALL"?

here is the code:

What area of the city would you like to dine in?
<?php
$db=mysql_connect("localhost", "******", "*********");

mysql_select_db("*******", $db) OR DIE ("died at connect");

$query = "SELECT DISTINCT Restaurant.Area ";
$query .= "FROM Restaurant ";
$query .= "ORDER BY Restaurant.Area ASC ";
$mysql_result=mysql_query($query, $db) OR DIE ("died at query");

$select="<select name=\"AreaTemp\">\n";
$select.="<option value=\"ALL\">ALL</option>\n";
        while(list($AreaTemp)=mysql_fetch_array($mysql_result)) {       

                $select.="<option value=\"$AreaTemp\">$AreaTemp</option>\n";

        }

        $select.="</select>";
echo "$select";
          ?>
          <br>
          What type of cuisine do you feel like?


<?php
$query = "SELECT DISTINCT Restaurant.Cuisine ";
$query .= "FROM Restaurant ";
$query .= "ORDER BY Restaurant.Cuisine ASC ";
$mysql_result=mysql_query($query, $db) OR DIE ("died at query");

$select="<select name=\"CuisineTemp\">\n";
$select.="<option value=\"ALL\">ALL</option>\n";
        while(list($CuisineTemp)=mysql_fetch_array($mysql_result)) {    

                $select.="<option
value=\"$CuisineTemp\">$CuisineTemp</option>\n";

        }

        $select.="</select>";
echo "$select";

?>

          <br>

          <input type ="submit" value="Go!" name="submit">
          <input type="RESET" value="Clear" name="RESET">
Scott Stinsman
Academic Coordinator
General Internal Medicine
1215 Blockley Hall
423 Guardian Drive
Philadelphia, PA  19104-6021
(phone)  215-662-7623
(fax)  215-349-5091
(email)  [EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to