SelectWhere

SelectWhere

This method returns and saves code of query SELECT, this query finds data saved in the table. Syntax:
$object->selectWhere(string $table, mixed $array[, bool $all = true[, string $order = NULL[, string $orderType = "ASC"[, array $cols = array("*")]]]])

Object

- Object of extension.

Table

- Table name.

Array

- String of SQL condition or array, where key is column name and value is its value. When all respectively one is true, this row is going to be selected.

All

- If it’s TRUE, the row will be selected only when all conditions are true, else row will be selected when whichever condition is true.

Order

- Name of column, which will be order argument. If it’s NULL, order argumant will be time of adding.

OrderType

- ASC or DESC, order direction.

Cols

- List of columns with values, which will fetch(), fetchArray() or fetchAll() method return. If it’s array("*"), these methods will return all columns.