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