PEAR Manual
Prev |  | Next

# ->whereAdd()

->whereAdd() -- Add WHERE statement

## Synopsis

``void $DB_DataObject->whereAdd` ([string $where [, string $logic]])`

## Description

Adds items to the where part of a SQL query. Calling this without any arguments clears the where condition. The default behavior is to add 'AND' to the existing conditions, use the $logic parameter to append OR conditions.

## Parameter

- `string $cond` - condition to add, or blank to reset the conditions

- `string $logic` - optional logic "OR" (defaults to "AND")

## Note

This function can not be called statically.

## See

## Example

Example 33-1. Using whereAdd()
    $person = new DataObjects_Person;
    $person->whereAdd('age > 12');
    $person->whereAdd('age < 30');
    $person->find();

    while ($person->fetch()) {
        echo "$person->id} {$person->name}<BR>";
    }
    $person = new DataObjects_Person;
    $person->whereAdd('age < 12');
    $person->whereAdd('age > 30', 'OR');
    $person->find();

    while ($person->fetch()) {
        echo "$person->id} {$person->name}<BR>";
    }

Example 33-2. Resulting SQL
    SELECT * FROM person WHERE age > 12 AND age < 30

    SELECT * FROM person WHERE age < 12 OR age > 30

Prev | Home | Next
->selectAdd() | Up | ->escape()