Welcome, Guest. Register Now!
06-03-2008, 09:08 PM
|
|||
|
|||
Zend_Db_Select with column prefixes
Hi there,
iam searching for a convenient way to select all fields from 2 small tables and get the result columns prefixed with their tablenames without specifiyng an alias for each column. e.g. Code:
$select = $db->select()
->from("book" )
->from("publisher" )
->where("book.publisher_id = publisher.id")
->where("book.id = ?", $id );
- title - created - changed - created_by so the resultset will contain for e.g. only the field "title" and it contains the title from book or the title from publisher. is there a way to get the resultset back that it is prefixed with their tables )without specifiying all aliasses)? like book.title publisher.title regards Treeda     
|
 |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
