member list
Posted: Fri Jul 26, 2002 8:21 pm
o.k. i'm obivously creating a member list.... and it SHOULD be easy but its not working i'm incompetent ..... help!!
i have this:
as you can see i want to order all the users in users table by their id... so i want 2 arrays....
one for each row... then inside that i want an associative array..
i want to output the first 20 people...
but nothing shows up
i have this:
Code: Select all
$qry = mysql_query ("SELECT * FROM users ORDER BY id LIMIT 1,20");
$row = array(mysql_fetch_assoc($qry));
for ($i = 0; $i < $rows; $i++){
echo "<TR><TD ALIGN=CENTER VALIGN=TOP WIDTH="5%">";
echo $rowї$i]ї'id'];
echo "</TD>";
echo "<TD ALIGN=LEFT VALIGN=TOP>";
echo $rowї$i]ї'login'];
echo "</TD>";
echo "<TD ALIGN=CENTER VALIGN=TOP>";
echo $rowї$i]ї'date'];
echo "</TD></TR>";
}one for each row... then inside that i want an associative array..
i want to output the first 20 people...
but nothing shows up