Honoroury GMs $result2 = mysql_query("SELECT name, gender FROM characters WHERE gm = 2 order by createdate") or die(mysql_error()); echo ""; echo ""; // keeps getting the next row until there are no more to get while($row = mysql_fetch_array( $result ) ) { echo ""; } echo "  Character   Name   Gender    "; echo ""; echo "   "; echo $row['name']; echo "   "; echo $res[$row['gender']]; echo " "; ?>