|
@@ -131,7 +131,7 @@ discard block |
|
|
block discarded – undo |
|
131
|
131
|
|
|
132
|
132
|
/**
|
|
133
|
133
|
* Returns the limit SQL for the current query as a string
|
|
134
|
|
- * @param integer|array $limit This should either be set as an integer or should be set as an array with a start and end value
|
|
|
134
|
+ * @param integer $limit This should either be set as an integer or should be set as an array with a start and end value
|
|
135
|
135
|
* @return string|false Will return the LIMIT string for the current query if it is valid else returns false
|
|
136
|
136
|
*/
|
|
137
|
137
|
private function limit($limit = 0){
|
|
@@ -171,7 +171,7 @@ discard block |
|
|
block discarded – undo |
|
171
|
171
|
* @param array $where Should be the field names and values you wish to use as the where query e.g. array('fieldname' => 'value', 'fieldname2' => 'value2', etc).
|
|
172
|
172
|
* @param string|array $fields This should be the records you wis to select from the table. It should be either set as '*' which is the default or set as an array in the following format array('field', 'field2', 'field3', etc).
|
|
173
|
173
|
* @param array $order This is the order you wish the results to be ordered in should be formatted as follows array('fieldname' => 'ASC') or array("'fieldname', 'fieldname2'" => 'DESC') so it can be done in both directions
|
|
174
|
|
- * @param integer|array $limit The number of results you want to return 0 is default and returns all results, else should be formated either as a standard integer or as an array as the start and end values e.g. array(0 => 150)
|
|
|
174
|
+ * @param integer $limit The number of results you want to return 0 is default and returns all results, else should be formated either as a standard integer or as an array as the start and end values e.g. array(0 => 150)
|
|
175
|
175
|
*/
|
|
176
|
176
|
protected function buildSelectQuery($table, $where = array(), $fields = '*', $order = array(), $limit = 0){
|
|
177
|
177
|
if(is_array($fields)){
|
|
@@ -209,7 +209,7 @@ discard block |
|
|
block discarded – undo |
|
209
|
209
|
* @param array $where Should be the field names and values you wish to use as the where query e.g. array('fieldname' => 'value', 'fieldname2' => 'value2', etc).
|
|
210
|
210
|
* @param string|array $fields This should be the records you wis to select from the table. It should be either set as '*' which is the default or set as an array in the following format array('field', 'field2', 'field3', etc).
|
|
211
|
211
|
* @param array $order This is the order you wish the results to be ordered in should be formatted as follows array('fieldname' => 'ASC') or array("'fieldname', 'fieldname2'" => 'DESC')
|
|
212
|
|
- * @param integer|array $limit The number of results you want to return 0 is default and returns all results, else should be formated either as a standard integer or as an array as the start and end values e.g. array(0 => 150)
|
|
|
212
|
+ * @param integer $limit The number of results you want to return 0 is default and returns all results, else should be formated either as a standard integer or as an array as the start and end values e.g. array(0 => 150)
|
|
213
|
213
|
* @param boolean $cache If the query should be cached or loaded from cache set to true else set to false
|
|
214
|
214
|
* @return array Returns a multidimensional array with the chosen fields from the table
|
|
215
|
215
|
*/
|