On Sun, 4 Aug 2002 17:42:17 +0200
Pierre-Alain Joye <[EMAIL PROTECTED]> wrote:
> On Sun, 4 Aug 2002 17:30:31 +0200
> "John Fishworld" <[EMAIL PROTECTED]> wrote:
> For a specific day, here the current day
WHERE DAYOFMONTH(t_event_date)=DAYOFMONTH(NOW()) AND MONTH(t_event_date)=MONTH(NOW())
if yo
On Sun, 4 Aug 2002 17:30:31 +0200
"John Fishworld" <[EMAIL PROTECTED]> wrote:
Why not simply does the where clause like :
for a whole month, here is july:
WHERE YEAR(t_event_date)='2002' AND MONTH(t_event_date)='7'
For a specific day, here the current day
WHERE t_event_date=NOW()
That means yo
> I thought I had this working, but it seems unfortunately not !!!
>
> I'm trying to list events for each month and my select query is as follows
>
> SELECT DISTINCT t_city_name,t_city_id_city FROM
> t_city,t_zipcodecity,t_location,t_event WHERE (t_city_id_city =
> t_zipcodecity_id_city) AND (t_
