My MySQL table contains a column Date and various other columns; there are about 5000 records, and Date can have one of about 20 values. I want to make dropdown list containing the various values of Date and the number of records containing this Date: something like
Code:
SELECT Date AS ThisDate, (COUNT(*) Date WHERE Date=ThisDate) FROM MyTable