->query()

Description

Sends a raw query to database. Often you may consider that using a large number of whereAdd's and orderBy method calls are not neccessary, and it would be simpler to just write the query, to make the code clearer and shorter.

Parameter

• string $string - SQL Query

Note

This function can not be called statically.

Example

       
<?php
$person = new DataObjects_Person;
$person->query("SELECT * FROM {$person->__table} WHERE id > 12 ORDER BY id");
while ($person->fetch()) {
  echo $person->name;
}
?>