Re: [PHP-DB] Grouped sql output

Hi Rudi, What do you think ? There are some problems. I'll test it tomorrow at work. I'll let you know how she goes. How did you get on? Regards, =dn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Grouped sql output

. - Original Message - From: DL Neil [EMAIL PROTECTED] To: Rudi Starcevic [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, March 01, 2002 9:05 AM Subject: Re: [PHP-DB] Grouped sql output Hi Rudi, What do you think ? There are some problems. I'll test it tomorrow

Re: [PHP-DB] Grouped sql output

Thanks Sven, I've already got the sql OK. I have the records set but I want to print it report like So It's needs some thing like a loop with an inner loop Like ol lizip ul licustomer licustomer /ul lizip ul licustomer licustomer /ul /ol Hope this makes sense. I'll elaborate more if you

Re: [PHP-DB] Grouped sql output

Hi, I've done this before in coldfusion. It's the one thing I'm note sure on how to do the same(ish) in PHP - my language of choice. If we have the record set the CF code would look like ul cfoutput query=customers group=zip !--- loop through record set --- li#zip# ol cfoutput !--- inner loop

Re: [PHP-DB] Grouped sql output

Hi Rudi, I've been struggling for a while now so I thought I'd ask. What's the easiest way to for to print group sql output. For example I need to output customers grouped by zip. Like: zip customer a customer b zip customer d customer e zip customer c custoemr f customer g Do I

Re: [PHP-DB] Grouped sql output

Hi Rudi, I've done this before in coldfusion. It's the one thing I'm note sure on how to do the same(ish) in PHP - my language of choice. If we have the record set the CF code would look like ul cfoutput query=customers group=zip !--- loop through record set --- li#zip# ol cfoutput

RE: [PHP-DB] Grouped sql output

] Subject: Re: [PHP-DB] Grouped sql output Hi, I've done this before in coldfusion. It's the one thing I'm note sure on how to do the same(ish) in PHP - my language of choice. If we have the record set the CF code would look like ul cfoutput query=customers group=zip !--- loop through record set

RE: [PHP-DB] Grouped sql output

Hi, Thanks for the input, I'll stop messing around and post some code Be warned this code is untested :-) It's kinda like thinking out loud. I think this should produce a nested list output from a query. Given this query : SELECT count(zip) AS zipcount,zip,cust_last_name FROM customers GROUP BY