query help
| From: | Stinsman, Scott | Date: | Mon, 12 Feb 2001 20:52:56 +0000 |
| Subject: | query help | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-6554@lists.php.net to get a copy of this message | ||
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) scott.stinsman@uphs.upenn.edu