[PHP] Re: [PHP-DB] Re: [PHP] Query - Grouping Results

2001-03-19 Thread Darryl Friesen
> Doesn't seem to work, how would I print that out with PHP? The results will come back sorted by name, then time. While processing each row, you'll need to keep track of when the username changes, something like this (this is just rough code, not quite valid PHP): $username = ''; while

Re: [PHP] Query - Grouping Results

2001-03-19 Thread Jordan Elver
Doesn't seem to work, how would I print that out with PHP? On Monday 19 March 2001 13:52, you wrote: > how about something like > select distinct > name, > date_format(time, "%W %D %M %Y") as login > from > users, user_logins > where > user_logins.user_id = users.id > or

RE: [PHP] Query - Grouping Results

2001-03-19 Thread Jeff Armstrong
how about something like select distinct name, date_format(time, "%W %D %M %Y") as login from users, user_logins where user_logins.user_id = users.id order by name,time -Original Message- From: Jordan Elver [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 20