hi,
i have a problem with returning and using the data from a table. I use this query to access the login names of the users from the table member: "select login from member". This works in the mysql command prompt. To extract the information i used two methods both of which only return one login name:
1.
$query = "select login from member";
$result = mysql_query($query) or die (mysql_error());
while ($row = mysql_fetch_array($result)) { $person = $row["login"];
echo "$person";
}
2.
$query = "select login from member";
$result = mysql_query($query) or die (mysql_error());
$row = mysql_fetch_array($result);
extract($row);
for ($i = 0; $i < count($row); $i++) {
echo "$row[$i]";
}
Any help would be appreciated. I am stumped...
bakaneko
