displaying data from database

[susi]

hi..
i have a login system where people have to pick a team name..
this goes into my database fine.

how do i call the team names for all my members and display them on a team list page???

i have a select statement where it only displays the first teamname in my database...

as follows

Query compilation

$qstr = "SELECT * from members3;

Query execution

$result = mysql_query($qstr);

Query detail specification

$row = mysql_fetch_array($result);

The player will be accessible as

//echo $row['teamname'];

any ideas??

[xblue]

fetch the records in a while loop, like this

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

[susi]

when i did that...

i got the error

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in /users/cais3/shicke-cais3/public_html/Footie1/Team List.php on line 12

any ideas??

thanks in advance!

[ir4z0r]

you've probably missed a " or used it wrong, check previous lines, too