cms_db_select

Produces SQL SELECT query for specified fields within given contstraints, and returns results as array of hashes

array cms_db_select( array $table [, $fields = false, array $constraint = false, int $limit = 0, int $begin = 0, array $order = false, array $group = false] )

Parameters

• array $table Tables to select from (when specified as 4-,5-,7- el. array it is treated as LEFT JOIN)
• mixed $fields
• array $constraint Constraints in the form of array fieldname => reqvalue
• int $limit Limit number of returned rows
• int $begin Skip number of returned rows
• array $order Order returned with fieldname => order (ASC, DESC)
• array $group Group returned elements by

Returns

• array of arrays Array of hashes for each returned row