really weird

[bakaneko]

i ran this query in mysql dos window "select login from member" which returns all the logins from the table, member. Two names are displayed, but when i ran the same query in php the first name shows and the second is blank...

$query = "select login from member";
$result = mysql_query($query) or die (mysql_error());
$row = mysql_fetch_array($result);
extract($row);
echo "$row[0], $row[1]";

Am i missing something really obvious here?

=/

[zmola]

Hi. Perhaps try...

$query = "select login from member"; 
$result = mysql_query($query) or die (mysql_error()); 
while ($row = mysql_fetch_array($result)) { 
echo $row["login"];
}

Cheers.