I'm trying to get all the users in members, and sort them by their user id. This is what I used.
$r = mysql_query("SELECT user FROM members ORDER BY id");
That works fine, but when I try to get it into an array...
$users = mysql_fetch_array($r);
mysql_fetch_array() will only return the first entry the SQL statement asked for. SO, the array $users will always only have one item, and I KNOW there's more than one entry in there.
Is there perhaps a function more suited to my needs?
$r = mysql_query("SELECT user FROM members ORDER BY id");
That works fine, but when I try to get it into an array...
$users = mysql_fetch_array($r);
mysql_fetch_array() will only return the first entry the SQL statement asked for. SO, the array $users will always only have one item, and I KNOW there's more than one entry in there.
Is there perhaps a function more suited to my needs?