note 13431 added to ref.mysql.php

Another quick and simple example which extracts the reslults as variables. Just don't know how fast it is compared with extract, anyway here is: $result = mysql_query("select id, name, address, occ from table"); // Assign the variables into the array: while(list($id, $name, $address, $occ) = mysql_fetch_row($result)) { //Now do what you want: echo "<table width=\"80%\"><tr>\n" ."<td><a class=\"main\" href=\"users.php?id=$id\">$name</a></td>" ."<td>$address</td><td>$occ</td>\n" ." </tr></table>\n"; } Best Regards! João Paulo M. Fischer http://www.php.net/manual/en/ref.mysql.php