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