generate basic report

[jonathen]

Hi all,

Basic one really, but I can't get it into my head how to do it. I have a database, and one of the tables has data in which is added each time a user completes a form. Each user has a unique id, so the table has several rows with the same user id appended to it.

What I am trying to do is generate a basic report - to get the total amount of records created by each user. So for example, if user_id 27 has created 12 records, and user_id 28 has created 7 records, the output would be:

user_id: 27 records: 12
user_id: 28 records: 7

...and so on. I have already pulled the user_id's from the users table, all I need to now do is match those user_id's with the user_id's from the records table to generate the results.

Any ideas?

TIA

Jonathen

[bad76]

Hi,
you have to get a look at SQL language.

However, may be is enough do a query like this:

SELECT UserName, COUNT(User_id)
FROM mytable
GROUP BY User_id

see you

[jonathen]

Thanks - I managed to get it working in the end using something similar.