From: rDubya [EMAIL PROTECTED]
Thanks for the help so far guys!!
Not helping though. I have the date contained in the database as timestamp
(-MM-DD HH:MM:SS).
Do you really need to pull events from the database which are not in your
range of interest? This will only slow down your
From: Instruct ICC [EMAIL PROTECTED]
And while not trusting your indexing, rewrite short_date as:
My short_date rewrite was also wrong. So it looks like you will have to
learn those offsets for this function if you do it on the PHP side. But you
could also do it on the MySQL side.
Hi!
I am designing a contact management system, so that entries (client
records) can be flagged, so that an email is sent out after 'n' months,
to remind the user to contact this particular client.
So, there would simply be a drop down menu with options: None, 1 month,
2 month, ... 12
This DID work, but I recently switched hosting companies...
Is the new server in a different country with a different date format
/ time zone?
Just a thought ;-\
On 9/7/07, Instruct ICC [EMAIL PROTECTED] wrote:
From: Instruct ICC [EMAIL PROTECTED]
And while not trusting your indexing,
WOW!! Thanks for all the help guys!! And Instruct ICC.. you're
solution for pulling the events did work.. but.. it turns out that
the solution was actually much simpler than I thought:
The old mysql database (once again, not sure what version) stored the
date as MMDDHHMMSS. The new