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
Barry,
On Thu, Jul 24, 2003 at 11:22:28PM -0500, Barry Hayden wrote:
I have to admit I am very much a newbie at MySQL in general (but I'm
working on it).
I have a fairly complex (for me) query that I am trying to complete
using php. I can't get it to work, and I'm sure it's just in the way
On Friday 25 July 2003 02:02 am, Fred van Engen wrote:
$sql = SELECT Realtor, HouseAddress, Bathrooms,
Bedrooms, YearBuilt, Garage, Location, Basement, Info
FROM properties WHERE Bathrooms =='.$a.', Bedrooms
=='.$b.', Garage =='.$c.',
Basement =='.$d.';
Use = for equality tests
I have to admit I am very much a newbie at MySQL in general (but I'm
working on it).
I have a fairly complex (for me) query that I am trying to complete
using php. I can't get it to work, and I'm sure it's just in the way I
am phrasing the MySQL part of this. The premise of this is a four