> What is the line code to optain the system date? > I propose is to compare the system date with the date in one field in the > database... Then what would be the mysql command to select all the rows > with > date with 10 days or less from the system date?
NOW, CURDATE(), or CURRENT_DATE SELECT * FROM your_table WHERE your_date_column > NOW() - INTERVAL 10 DAY; ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
