Zend_Db_SelectClass for SQL SELECT generation and results.
Located in /Zend/Db/Select.php (line 36)
Zend_Db_Adapter_Abstract
$_adapter
(line 43)
Zend_Db_Adapter_Abstract object.
array
$_parts
= array(The component parts of a SELECT statement.
array
$_tableCols
= array() (line 69)
Tracks which columns are being select from each table and join.
distinct (line 175)
Makes the query SELECT DISTINCT.
forUpdate (line 188)
Makes the query SELECT FOR UPDATE.
from (line 202)
Adds a FROM table and optional columns to the query.
group (line 368)
Adds grouping to the query.
having (line 395)
Adds a HAVING condition to the query by AND.
If a value is passed as the second param, it will be quoted and replaced into the condition wherever a question-mark appears. See where() for an example
join (line 253)
Adds a JOIN table and columns to the query.
joinInner (line 280)
Add an INNER JOIN table and colums to the query
joinLeft (line 267)
Add a LEFT JOIN table and colums to the query
limit (line 475)
Sets a limit count and offset to the query.
limitPage (line 490)
Sets the limit and count by page number.
order (line 446)
Adds a row order to the query.
orHaving (line 423)
Adds a HAVING condition to the query by OR.
Otherwise identical to orHaving().
orWhere (line 345)
Adds a WHERE condition to the query by OR.
Otherwise identical to where().
where (line 317)
Adds a WHERE condition to the query by AND.
If a value is passed as the second param, it will be quoted and replaced into the condition wherever a question-mark appears. Array values are quoted and comma-separated.
Note that it is more correct to use named bindings in your queries for values other than strings. When you use named bindings, don't forget to pass the values when actually making a query:
_join (line 228)
Populate the $_parts 'join' key
Does the dirty work of populating the join key.
_tableCols (line 508)
Adds to the internal table-to-column mapping array.
__toString (line 88)
Converts this object to an SQL SELECT string.
Documentation generated on Tue, 11 Jul 2006 12:18:04 -0500 by phpDocumentor 1.3.0RC6