maxitee - 4:46 pm on Sep 30, 2011 (gmt 0)

JUST INCASE YOU REQUIRE MORE EXPLANATION... what i want to achieve is something like this..
Say,
You have a database with 2 tables.. Say table AGENTS stores data of John Doe(name) 123 advertisers(Agency) and so on

While, table USERS stores data of Mary Doe(name) 123 advertisers(Agency)

Mary Doe is a customer that was refered by 123 advertisers... The HTML TABLE i'm trying to achieve does not even care about John Doe's name.. All it cares about is his 123 advertisers company name..

So that my HTML table looks something like

NAME OF ADVERT COMPANY..................... NUMBER OF CLIENTS
123 ltd. ........................................ 32
abc ltd. ........................................ .. 12
xyz ltd. ........................................... 14


NOTE( total number of advert company is NOT static.. we continually get new entries from companies as well.)


The above is the basic concept.... Though i am also interested in knowing number of Clients with pets or with kids from each respective ADVERT COMPANY.... If someone can however help me with the basic concept above, i am sure i will be able to use it to obtain more data.