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['cat_id'] . '\' AND type=0 AND status=1 AND tim<' . $_GET['tim'] . ' ORDER by tim DESC LIMIT 10';



i want to edit it to show every day all articles inserted in the last 7 days from table articles ....

how can i edit this query??
please help me any body as fast as you can
many thankx for your efforts :)

_________________________________________________________________
Check the weather nationwide with MSN Search: Try it now! http://search.msn.com/results.aspx?q=weather&FORM=WLMTAG

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

Reply via email to