MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: PHP/MySQL date < CURDATE() problem
Posted by: Luke Godfrey
Date: December 27, 2007 07:21PM

I figured out how to make it work, but I still would like to know exactly why the first method didn't work. Here's what I did:

DELETE FROM events WHERE CONCAT(YEAR(date),'-',MONTH(date),'-',(DAY(date) + 1)) <= CURDATE()

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
PHP/MySQL date < CURDATE() problem
Luke Godfrey
December 27, 2007 07:17PM
Re: PHP/MySQL date < CURDATE() problem
Luke Godfrey
December 27, 2007 07:21PM
Re: PHP/MySQL date < CURDATE() problem
Greg Platt
December 28, 2007 01:13PM
Re: PHP/MySQL date < CURDATE() problem
Greg Platt
December 28, 2007 01:16PM
Re: PHP/MySQL date < CURDATE() problem
Greg Platt
December 28, 2007 01:22PM
Re: PHP/MySQL date < CURDATE() problem
Greg Platt
December 28, 2007 01:54PM
Re: PHP/MySQL date < CURDATE() problem
Brian Papantonio
December 28, 2007 02:23PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.