YouTipPdostatement Setfetchmode
# PDOStatement::setFetchMode
[PHP PDO Reference](#)
PDOStatement::setFetchMode — Sets the default fetch mode for a statement. (PHP 5 >= 5.1.0, PECL pdo >= 0.2.0)
* * *
## Description
### Syntax
bool PDOStatement::setFetchMode ( int $mode )bool PDOStatement::setFetchMode ( int $PDO::FETCH_COLUMN , int $colno )bool PDOStatement::setFetchMode ( int $PDO::FETCH_CLASS , string $classname , array $ctorargs )bool PDOStatement::setFetchMode ( int $PDO::FETCH_INTO , object $object )
* * *
## Parameters
**mode**
The fetch mode must be one of the PDO::FETCH_* series of constants.
**colno**
Column number.
**classname**
Class name.
**ctorargs**
Constructor arguments.
**object**
Object.
* * *
## Return Values
Returns TRUE on success or FALSE on failure.
* * *
## Examples
### Setting the fetch mode
The following example demonstrates how to use PDOStatement::setFetchMode() to change the default fetch mode for a PDOStatement object.
query($sql); $result = $stmt->setFetchMode(PDO::FETCH_NUM); while ($row = $stmt->fetch()) { print $row . "t" . $row . "t" . $row . "n"; }}catch (PDOException $e) { print $e->getMessage();}?>
The above example will output:
apple red 150 banana yellow 250 orange orange 300 kiwi brown 75 lemon yellow 25 pear green 150 watermelon pink 90
[PHP PDO Reference](#)