Re: Grouped sql output
| From: | Rudi Starcevic | Date: | Tue, 26 Feb 2002 10:51:43 +0000 |
| Subject: | Re: Grouped sql output | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17295@lists.php.net to get a copy of this message | ||
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>
<li>zip
<ul>
<li>customer
<li>customer
</ul>
<li>zip
<ul>
<li>customer
<li>customer
</ul>
</ol>
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 build array's and loop through them or
> can I print straight from a record set ( using Postgresql
> or Mysql ) Thanks heaps ! Regards Rudi.
>
> =============================================================
> Get your personalised email and homepage at www.easymail.info
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
=============================================================
Get your personalised email and homepage at www.easymail.info