/*here is a nice function for converting 
a mysql result row set into a 2d array, 
a time saver if need small data from 
several rows, saves you from having to 
do Alot of queries... would be nice to 
have this built into PHP future versions :) */

// simple example query

$r = mysql_query("select user,id,ip from accounts limit 10");

// starts the for loop, using mysql_num_rows() to count
// total amount of rows returned by $r

for($i=0; 
    $i<mysql_num_rows($r); 
    $i++)
{
  // advances the row in the mysql resource $r
  mysql_data_seek($r,$i);
  
  // assigns the array keys, $users[row][field]
  $users[$i]=mysql_fetch_row($r);
}

// simple, hope someone can use it :)
// -Kenneth Nash