PEAR::DB replacement class

The getAll() Method

This method returns the entire result set. It shouldn't really be used for big data sets as that will usually impair performance.

<?php
    $users = $db->getAll("SELECT * FROM users");
?>

You can also specify the fetch mode:

<?php
    $users = $db->getAll("SELECT * FROM users", DB_FETCHMODE_ASSOC);
?>