Thanks to everyone who helped so quickly =) Based on what people said, I
was able to come up with a solution. The goal was to get a total number of
log entries from a given month and year. The query we came up with is:
select count(*) as Total from log where month(datestamp) = '$current_mont
.WHERE monthcol=MONTH(now()). I think this should work.
> Hi =)
>
> Could you help? I have a table with a datetime field and I'm trying to
> figure out how to format an SQL query to select records only from within
> the current month. Any help would be greatly appreciated.
>
> Thanks,
>
Hi =)
Could you help? I have a table with a datetime field and I'm trying to
figure out how to format an SQL query to select records only from within
the current month. Any help would be greatly appreciated.
Thanks,
-Ed
-
