[RESOLVED] Need query help with date_format

[rprincejr]

Im trying to create a query that will only call results based on $day. The problem is that the date in the database is stored as 0000-00-00 as a date field.

Heres my query Im trying to get to work.

$query = "SELECT event, event_cat, DATE_FORMAT(event_date, '%d') AS d FROM calendar WHERE  d='$day'";

.

Any help would be appreciated.

[devinemke]

i assume $d is simply the day of the month?

$query = "SELECT * FROM calendar WHERE DAYOFMONTH(event_date) = '$day'";

[rprincejr]

Very nice. That was exactly what I needed. Thx alot!

Thread resolved.