Re: mySQL/php query help

2001-02-14 Thread Tobias Talltorp
uot;; > $query .= "ORDER BY Restaurant.Price "; > $mysql_result=mysql_query($query, $db) OR DIE ("died at query"); > > -code here- > > > -Original Message- > From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, Febr

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 Rolf Hopkins
nsman, Scott" <[EMAIL PROTECTED]> To: "'Rolf Hopkins'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, February 14, 2001 23:29 Subject: RE: mySQL/php query help > hey rolf-- > > everything works fine if the user chooses "ALL&quo

RE: mySQL/php query help

2001-02-14 Thread Stinsman, Scott
Original Message - From: "Stinsman, Scott" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 13, 2001 23:17 Subject: mySQL/php query help > can anyone figure out why the following code works fine when both select > variables = "ALL" and also

Re: mySQL/php query help

2001-02-13 Thread Rolf Hopkins
PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 13, 2001 23:17 Subject: mySQL/php query help > 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 var

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