[UPHPU] mysql report

[Scott Hill]

On 8/15/06, Ash <ashovi at qwest.net> wrote:
>
> Are there any good php reporting tools out there? I have a database I
> need to get a report from. A sample of the data looks like this:
>
> "","Prima Neighbor","","","","1641 Prima
> Drive","","Livermore","CA","94550","15192"
> "","Prima Neighbor","","","","238 Prato
> Way","","Livermore","CA","94550","15192"
> "","Prima Neighbor","","","","1686 Vetta
> Drive","","Livermore","CA","94550","15192"
> "","Prima Neighbor","","","","167 Campo
> Court","","Livermore","CA","94550","15555"
> "","Prima Neighbor","","","","26 Raccolio
> Way","","Livermore","CA","94550","15555"
> ","Prima Neighbor","","","","1641 Prima
> Drive","","Livermore","CA","94550","1666"
> "","Prima Neighbor","","","","238 Prato
> Way","","Livermore","CA","94550","1666"
> "","Prima Neighbor","","","","1686 Vetta
> Drive","","Livermore","CA","94550","16666"
> "","Prima Neighbor","","","","167 Campo
> Court","","Livermore","CA","94550","17777"
> "","Prima Neighbor","","","","26 Raccolio
> Way","","Livermore","CA","94550","17777
>
> The last number is the customer #. I need to know how many contacts each
> customer has, so the report would look something like this (I don't care
> much about the format, just that the info is there):
>
> 15192-- 3
> 15555-- 2
> 16666-- 3
> 17777-- 2
>
> Any ideas?
>
> Thanks,
>
> Ash



If you don't care about the format, why not load the info into a MySQL
database, create the SQL grouping by customer number and then display it
with html?  Email a link to anyone who needs to see the information.

My $.02 worth.

P.S. IMHO, most reporting tools are mostly for formatting and making the
report pretty.

-- 
Scott Hill

"May you solve interesting problems" - Author Unknown
"A fanatic is one who can't change his mind and won't change the subject." -
Sir Winston Churchill