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

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

[PHP] Problems processing UNIX timestamps in events directory

2007-02-20 Thread Dave Goodchild
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 database for all events whose

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

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 database

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