SELECT AS problem

[eluser]Unknown[/eluser]
I am having difficult time with a SELECT statement in the controller such as

"SELECT listings.brup + listings.brdown + listings.brlower AS bedrooms"

Thats a fragment, the rest of the SELECT statement works fine.

My problem is that in the view I cannot seem to get the alias "bedrooms" to be recognized.

I get the message: Message: Undefined property: stdClass::$bedrooms

I am new to OOP and codeigniter. I am not so much asking for a solution as I am wanting to know were in the documentation SELECT AS statements are discussed.

Thanks,

Doug