Why might this statement only return one row

[Tyler Barton]

I have a test table that has 4 rows that fall into the conditions of this SQL statement but it is only returning 1.

My goal in all this is that I need a statement that returns all the rows that fall withing a range but I also need a count of the total number rows in the return.

This statement is to be used in a PHP page that is then encoded to JSON and passed to various functions.

SELECT *, COUNT(id) AS Total FROM icalendar.event where start between 1475280000000 and 1477958399000;

It returns one row with a column total = 4 which is correct, there should be 4 rows but it only returns one.

Thanks