RE: mySQL/php query help

2001-02-14 Thread Stinsman, Scott
"; $query .= "FROM Restaurant "; $query .= "WHERE '$CuisineTemp' = Restaurant.Cuisine AND '$AreaTemp' = Restaurant.Area "; $query .= "ORDER BY Restaurant.Price "; $mysql_result=mysql_query($query, $db) OR DIE ("died at query"); ---

RE: mySQL/php query help

2001-02-14 Thread Stinsman, Scott
but it does not work if the user wants a specific cuisine in a specific area and this is because the AreaTemp variable remains "ALL". does this help? any suggestions? --scott -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 8:30 PM T

mySQL/php query help

2001-02-13 Thread Stinsman, Scott
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? \n"; $select.="ALL\n"; w