[UPHPU] mysql report

Ash ashovi at qwest.net
Tue Aug 15 12:20:52 MDT 2006


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



More information about the UPHPU mailing list