[RESOLVED] counting number of entries by user

[dkrysak]

Hi there, I have a simple table where it houses entries made by individual users.

For example, say I have a table that holds:

-id
-user
-clientemail
-added

So I currently have working:

(selecting all rows within a range)

$sql = "SELECT * FROM myTable WHERE added BETWEEN ".$beginRange." and ".$endRange;

So now I need to modify that to do is get a total (number of rows entered) by each user within a date range.

Is there a way to do this within SQL directly? Or would i have to do something in php and manually build an array of results?

I need the final results to be an array holding the username, and the record count for that time frame.

[laserlight]

Perhaps you could do something like this:

$sql = "SELECT COUNT(*) FROM `myTable` WHERE `added` BETWEEN $beginRange AND $endRange GROUP BY user";

[dkrysak]

laserlight;10894858 wrote:

Perhaps you could do something like this:

$sql = "SELECT COUNT(*) FROM `myTable` WHERE `added` BETWEEN $beginRange AND $endRange GROUP BY user";

Well that put me on the right track!

I used:

SELECT staff, COUNT(email) AS Total FROM ccStaffTracker WHERE added BETWEEN 20081001000000 AND 20081031235959 GROUP BY staff

and seems to work!

[laserlight]

You're welcome 🙂
Remember to mark this thread as resolved (if it is) using the thread tools.