For further details, see also mysql_fetch_row() and mysql_fetch_assoc().
?php mysql_connect( $host,$user,$password); $result = mysql_db_query("database" ,"select * from table"); while($row = mysql_fetch_array($result)) {echo $row["user_id"]; echo $row["fullname"];} mysql_free_result($result);?