How do I make it so if there is more than one result, it will display them all?

Question

I wrote a script, but when searched brings only one set of results. How do I make it so if there is more than one result, it will display them all?

Answer 1

The only database specific functions are $db->query, $db->select and $db->db (the constructor function). All other functions use standard PHP code only. The other point to note is that the two main functions that return rows of results take an optional argument to specify whether to return the results as an associative array, numerical array or object (which is the default)

<?php

    if ( $server == "oracle8" )
        include_once "oracle8/ez_sql.php";
    else
        include_once "mySQL/ez_sql.php";

    $users = $db->get_results("SELECT * FROM users");

    foreach ( $users as $user )
    {
        echo $user->name;
        }

?>