Re: [PHP] Problems processing UNIX timestamps in events directory

2007-02-21 Thread Németh Zoltán
2007. 02. 21, szerda keltezéssel 09.33-kor Dave Goodchild ezt írta: > Thanks all for your input - you're all correct, I don't really need to use > timestamps as I am only interested in dates so will be reworking the app to > use dates only. I still need to generate sequences of dates and really don

Re: [PHP] Problems processing UNIX timestamps in events directory

2007-02-21 Thread Dave Goodchild
Thanks all for your input - you're all correct, I don't really need to use timestamps as I am only interested in dates so will be reworking the app to use dates only. I still need to generate sequences of dates and really don't want to deal with DST, so my question is: can I add days to dates with

Re: [PHP] Problems processing UNIX timestamps in events directory

2007-02-20 Thread Dave Goodchild
I AM using the logic you and Jochem suggest in the query, I am not performing any joins. I query for certain criteria re the start and end dates held in the database, and once I have my set I then work with it dynamically as I need to know, based on the event frequency, how many events from that r

Re: [PHP] Problems processing UNIX timestamps in events directory

2007-02-20 Thread Richard Lynch
On Tue, February 20, 2007 8:25 am, Dave Goodchild wrote: > I am building an events directory and when users search, they provide > a date > range ie Feb 16 2007 to March 12 2007 as one of the options for > searching. > The system then creates an array of timestamps from this and then Why would you

Re: [PHP] Problems processing UNIX timestamps in events directory

2007-02-20 Thread Jochem Maas
Dave Goodchild wrote: > Hi all. I have an odd problem. > > I am building an events directory and when users search, they provide a > date > range ie Feb 16 2007 to March 12 2007 as one of the options for searching. > The system then creates an array of timestamps from this and then polls the > dat

Re: [PHP] Problems processing UNIX timestamps in events directory

2007-02-20 Thread Arpad Ray
Dave Goodchild wrote: I have converted the user-friendly date output to timestamps to check and sure enough, when the user selects a start date before March 26 2007, March 26 2007 is output as: 1174863600 ...after that it becomes: 117486 ...a difference of 3600 Is this anything to do w