Hi, I'm trying to print out a list of usernames and the times they logged in. I want to print it out like: joe fred frank Then when you click on one of the names it show just there login times, like this, so if I click on fred it prints out: joe fred - <login time> - <login time> - <login time> frank But it doesn't continue printing out the rest of the usernames after it's finished printing freds logins. Any ideas would be appreciated. The code seems to have something to do with the second query, I think :-( The code I'm using is below. Thanks, Jord db_connect(); $sql = "SELECT id, username FROM users"; $result = @mysql_query($sql); if(@mysql_num_rows($result) > 0) { echo'This is a list of Members who have Logged In to their account with times and dates:<BR><BR>'; while(list($id, $username) = mysql_fetch_array($result)) { echo"<A HREF=\"$PHP_SELF?user=$username&id=$id\">$username</A><BR>\n"; if($username == $user) { $sql = "SELECT UNIX_TIMESTAMP(time) AS time FROM user_logins WHERE user_id = $id ORDER BY time DESC"; $result = @mysql_query($sql); while(list($time) = mysql_fetch_array($result)) { echo date('h:i a l d F', $time)."<BR>\n"; } } } } else { echo error('No one has Logged In yet!'); } -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]