Matching Dates

[eluser]james182[/eluser]
i get this error

Code:

A Database Error Occurred

Error Number: 1054

Unknown column '0' in 'where clause'

SELECT COUNT(*) AS `numrows` FROM (`default_eventcal`) WHERE `0` = '2012-08-04'

Filename: /xxx/calendar_m.php

Line Number: 13

and if i take out the where clause i get the count 5 which is kinda right, there is 5 events but 2 on one date, 2 on another and 1 on another.
so on those dates i should count 2, 2, 1