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]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php