[eluser]JayTee[/eluser]
[quote author="greenest" date="1197693042"]I am having difficult time with a SELECT statement in the controller such as
"SELECT listings.brup + listings.brdown + listings.brlower AS bedrooms"
[/quote]
First - you really shouldn't have any SQL in your controller - that's for the model!
It looks like you're trying to use SQL to put the three field values together?
Try this:
"SELECT CONCAT(listings.brup,listings.brdowm,listings.brlower) AS bedrooms FROM..."
Once you run the query, it could be something like:
$yourPHPObject->bedrooms to get the concatenated value.