block. )
Thanks
Rudi.
- 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,
>
> &
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
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
]]
Sent: 26 February 2002 11:02
To: [EMAIL PROTECTED]
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
#
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
>
>
>
> #zip#
>
>
> #customer#
>
>
>
>
>
> So I'm think also to use 2 loops for the sam
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
> custo
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
#zip#
#customer#
So I'm think also to use 2 loops for the same purpose in PHP.
Can I do this from
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
zip
customer
customer
zip
customer
customer
Hope this makes sense.
I'll elaborate more if you think I should.
Cheers
Rudi.
Hi friends,
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 need to bui