I've got a table like:

id      user_id         ip              time
1       2            20010316105018

Etc, etc.

I do a join on the this table and the users table to get the coresponding 
username to user_id like this:

SELECT users.name AS name, user_logins.ip AS ip, 
UNIX_TIMESTAMP(user_logins.time) AS time FROM users, user_logins WHERE 
user_logins.user_id = users.id ORDER BY time ASC

How can I display the results grouped by username?

So, I want to be able to display:

Logins for John

Thursday 10th
Friday 12th
Monday 23rd

Logins for Bob

Monday 1st
Tuesday 2nd
Saturday 31st

Thanks for any help,


PHP Database 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]

Reply via email to