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

2001-03-19 Thread Jordan Elver
d order by name,time -Original Message- From: Jordan Elver [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 1:43 PM To: PHP Database Mailing List; PHP General Mailing List Subject: [PHP] Query - Grouping Results Hi, I've got a table like: iduser_id ip

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

2001-03-19 Thread Jeff Armstrong
$column = $value) { echo " TD$valuenbsp;/TD\n"; } echo "/TR\n"; $row_count++; } echo "/TABLE\n\n"; ? -Original Message- From: Jordan Elver [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 3:03 PM To: Jeff Armstrong Cc: PHP Database Mailing Lis

Re: [PHP] Query - Grouping Results

2001-03-19 Thread Jordan Elver
Message- From: Jordan Elver [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 2:39 PM To: Jeff Armstrong Cc: PHP Database Mailing List; PHP General Mailing List Subject: Re: [PHP] Query - Grouping Results Doesn't seem to work, how would I print that out with PHP? On Monday 19 March

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

2001-03-19 Thread Jeff Armstrong
, March 19, 2001 1:43 PM To: PHP Database Mailing List; PHP General Mailing List Subject: [PHP] Query - Grouping Results Hi, I've got a table like: id user_id ip time 1 2 127.0.0.1 20010316105018 Etc, etc. I do a join on the this table and the u

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