RE: Delete by date?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> How would I do that?  I just did this:
> 
> $date = date("Y-m-d");
> 
> and changed my date field in my MySQL DB to use the Date format, I
don't
> know if that's correct though?  Then how would I get to delete all
before
> the current date?

DELETE FROM table WHERE date_column < CURDATE()

---John W. Holmes...

PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux