PEAR Manual
Prev |  | Next

# ->query()

->query() -- send a raw query

## Synopsis

``void $DB_DataObject->query` (string $string)`

## 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

Example 33-1. raw queries on the database
    $person = new DataObjects_Person;
    $person->query("SELECT * FROM {$person->__table} WHERE id > 12 ORDER BY id");
    while ($person->fetch()) {
      echo $person->name;
    }

Prev | Home | Next
Selecting Specific data (SELECT) | Up | ->free()