[PHP-DB] how to show all inserts in the last 7 days from a table

hey guys i want to know how to show all records inserted in the last 7 days in a table i use this query to show the last 10 articles from a table called - articles - where time is saved in the vairble - $tim - down is the query: $SQL = '' . 'SELECT * FROM articles WHERE category=\'' .

[PHP-DB] how to show all recordes inserts in a table for the last 7 days

hey guys i want to know how to show all records inserted in the last 7 days in a table i use this query to show the last 10 articles from a table called - articles - where time is saved in the vairble - $tim - down is the query: $SQL = '' . 'SELECT * FROM articles WHERE category=\'' .

[PHP-DB] Call Function On Session Destroy

Hi Guys, I have a question. Is it possible to call any function when the session expires in PHP? I want to do some database deletions whenever the session expires. Thanks Regards Manoj

RE: [PHP-DB] how to show all recordes inserts in a table for the last 7 days

Assuming that tim is a pure timestamp column then try select * from table where date_format(tim,'%Y-%m-%d) = DATE_SUB(curdate(), INTERVAL 7 DAY) Bastien From: Muhammad Mustafa [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] how to show all recordes inserts in a table for the