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_zipcodecity_zipcode = t_location_zipcode ) AND
((t_location_sex = 4) OR (t_location_sex = 6) OR (t_location_sex = 0)) AND
(t_location_id_location = t_event_id_location) AND (t_event_date <
(DATE_ADD('2002-08-01 00:00:00', INTERVAL 31 day)) ) AND (t_event_date >
'2002-08-01 00:00:00') ORDER by t_city_name
this is for August and seems to work fine, but my problem is that in the
running month I only want to show the still forthcoming events so for today
July the 31 st my query looks like this
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_zipcodecity_zipcode = t_location_zipcode ) AND
((t_location_sex = 4) OR (t_location_sex = 6) OR (t_location_sex = 0)) AND
(t_location_id_location = t_event_id_location) AND (t_event_date <
(DATE_ADD('2002-07-31 00:00:00', INTERVAL 0 day)) ) AND (t_event_date >
'2002-07-31 00:00:00') ORDER by t_city_name
But it doesn't work ??
Can anyone give me a hint in the right direction ??
The problem is definately in the last part ---- (t_event_date <
(DATE_ADD('2002-07-31 00:00:00', INTERVAL 0 day)) ) AND (t_event_date >
'2002-07-31 00:00:00')
Thanks in advance
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
