Date: 03/18/07 (PHP Community)    Keywords: mysql, database, sql

I have the following piece of code:

$sql = "SELECT id, alt_name, databasename, gametype FROM ".$_MB->db_name.".servers";
$res = mysql_query($sql, $_MB->connection) or die(mysql_error());
$row = mysql_fetch_assoc($res);
$_SMARTY->assign("server_list", $row);

It is supposed to return whatever rows are in the servers table, but for some reason it only returns the first. I've executed the SQL statement via MySQL directly and it acts as it should. Any ideas why it's acting wonky?

Source: http://community.livejournal.com/php/553452.html