Hi..

i am trying to call ALL da usernames and teamname in my members table! it is only dispaying one username/teamname.

this is my code..

<?
include("connect2db.php");

$result = mysql_query("select teamname, username from members");
## Query detail specification ##
$row = mysql_fetch_array($result);

while ($row = mysql_fetch_array($result)){
// output teamname and a line break
echo $row['teamname'];
echo $row['username'];
echo $row[2]."<br>";
}
?>

any ideas how to display all information on username/teamname in table instead of just one row????