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_

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 (t_zipc

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

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 (t