[Brad]

fetch_array is used to take the results from a query and turns them into arrays, making them easy to work with in php.

Lets take this for example:

I want to get the 5 newest usernames from my database, but I want to put a bit of text on a new line under the last username returned from mySQL.

So I write this line to query the data:

PHP Code:

$getusers = $DB_site->query("SELECT username FROM user ORDER BY userid DESC LIMIT 5"); 


That gets the 5 rows I need from mySQL, but how do I use them in the templates or in the rest of my page for that matter? Obviously $getusers dose nothing.

This is where fetch_array comes in.

As stated before I want to add text under the last username mySQL returned, which means I need to loop over the results (look at them one at a time). For the loop operation I will use the while function, you will notice fetch_array is called within this function, this is the most common useage of $DB_site->fetch_array(); within vBulletin.

So heres you basic code for the loop/fetch_array operation

PHP Code:

$looped_x_times = 0; // this var will tell us how many times the while loop has run
while ($users = $DB_site->fetch_array($getusers))
{
    // if we have already looped 4 times then this is the 5th run
    if ($looped_x_times == '4')
    {
        // append <br /> and 'Last result' to the username this run
        $users['username'] = ''.$user['username'].'<br />Last result';
    }

    // Outputs username of the member we are currently looking at in the loop
    echo($users['username']);
    
    /* 
    This will add 1 (+1) to the $looped_x_times var, so if looped_x_times is '0' this will set it to '1', and so on
    */
    $loop_x_times++; 


$DB_site->fetch_array is mysql_fetch_array(); in php, you can find out more info on mysql_fetch_array(); here: http://www.php.net/mysql_fetch_array