Fw: Select Date_Add help

Please ! 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)

Select Date_Add help

Please ! 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

Re: Date

Can someone help me with the correct sytax here ! I'm trying to show results from the last two days(or week etc) This is what I've got as my sql query SELECT . WHERE. AND ( (DATE_SUB(j.stellen.t_stellen_date INTERVAL 2 day) j.stellen.t_stellen_date) but it doesn't work !

Re: Temporary Tables

You have written the following: I understand the principles but WHEN should they be used or considered ?? Any help appreciated tia John sql,query - Before posting, please check: http://www.mysql.com/manual.php