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
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

Re: mySQL/php query help

2001-02-13 Thread Rolf Hopkins
I can't see anything wrong with your code? What exactly is the problem? Aren't the values, from the select statement printing out on your web page or something? Are you sure you provided the right code? - Original Message - From: "Stinsman, Scott" <[EMAIL PROTECTED]> To: <[EMAIL PROTECT