@@ -115,7 +115,7 @@ discard block |
||
115 | 115 | * Returns a single record for a select query for the chosen table |
116 | 116 | * @param string $table This should be the table you wish to select the values from |
117 | 117 | * @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). |
118 | - * @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). |
|
118 | + * @param string $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). |
|
119 | 119 | * @param array|string $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') |
120 | 120 | * @param boolean $cache If the query should be cached or loaded from cache set to true else set to false |
121 | 121 | * @return array Returns a single table record as the standard array when running SQL queries |
@@ -130,9 +130,9 @@ discard block |
||
130 | 130 | * @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). |
131 | 131 | * @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). |
132 | 132 | * @param array|string $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') |
133 | - * @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) |
|
133 | + * @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) |
|
134 | 134 | * @param boolean $cache If the query should be cached or loaded from cache set to true else set to false |
135 | - * @return array Returns a multidimensional array with the chosen fields from the table |
|
135 | + * @return boolean Returns a multidimensional array with the chosen fields from the table |
|
136 | 136 | */ |
137 | 137 | public function selectAll($table, $where = array(), $fields = '*', $order = array(), $limit = 0, $cache = true){ |
138 | 138 | $this->buildSelectQuery(String::makeSafe($table), $where, $fields, $order, $limit); |
@@ -367,7 +367,7 @@ discard block |
||
367 | 367 | * @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). |
368 | 368 | * @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). |
369 | 369 | * @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 |
370 | - * @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) |
|
370 | + * @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) |
|
371 | 371 | */ |
372 | 372 | protected function buildSelectQuery($table, $where = array(), $fields = '*', $order = array(), $limit = 0){ |
373 | 373 | if(is_array($fields)){ |
@@ -475,7 +475,7 @@ discard block |
||
475 | 475 | |
476 | 476 | /** |
477 | 477 | * Returns the limit SQL for the current query as a string |
478 | - * @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 |
|
478 | + * @param integer $limit This should either be set as an integer or should be set as an array with a start and end value |
|
479 | 479 | * @return string|false Will return the LIMIT string for the current query if it is valid else returns false |
480 | 480 | */ |
481 | 481 | private function limit($limit = 0){ |