Is it too late to change the way you insert dates into the DB?  I really
think the unix timestamp is the easiest way to store dates... comparisons
are easy, because everything is in seconds, and using date() gives you the
ability to re-format your dates over and over again for presentation

Just my 2 cents :)


on 11/11/02 4:04 PM, Michael P. Carel ([EMAIL PROTECTED]) wrote:

> hi to all again,
> I have a problem here again regarding the date comparison. I need to check the
> most recent date that was entered in mysql database in date format ("Y-m-d"),
> if the datetoday is a day or two days in advanced compared to the queried
> date.
> I need to make sure that the  next inserted date in the mysql database whould
> be the next day of  the last inserted date.
> Any idea how? Please help.
> Im trying to do something like this:
> //checking the queried date
> $querieddate=(2002-11-02);
> $incrementdate=date("$querieddate"),mktime(0,0,0,date(m), date(d)+1,date(Y)));
> $datetoday=("Y-m-d");
> if($incrementdate == $datetoday){
> //insert $datetoday to the mysql database
> }else{
> //insert $incrementdate to the mysql database
> }
> regards ,
> mike

Justin French
Creative Director
Web Developent & 
Graphic Design

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to