On 25-Jul-2003 Barry Hayden wrote:
<snip>
> $sql = "SELECT Realtor, HouseAddress, Bathrooms, Bedrooms, YearBuilt,
> Garage, Location, Basement, Info FROM properties
> WHERE Bathrooms =='".$a."'", "Bedrooms =='".$b."'", "Garage
> =='".$c."'",
> "Basement =='".$d."'";
Use '=' instead of '==' and why the commas in your WHERE clause ?
$sql = "SELECT Realtor, ...
WHERE Bathrooms ='$a' AND Bedrooms ='$b' AND ..."
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
