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: [email protected]
Subject: [PHP-DB] how to show all recordes inserts in a table for t
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
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=\'' . $_GET['c
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=\'' . $_G
