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
";
$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");
---
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
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
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