Date
| From: | John Fishworld | Date: | Wed, 22 May 2002 08:51:46 +0000 |
| Subject: | Date | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19348@lists.php.net to get a copy of this message | ||
Can someone help me with the correct sytax here !
I'm trying to show results from the last two days(or week etc)
This is what I've got
SELECT .....
WHERE.....
AND ( (DATE_SUB(j.stellen.t_stellen_date INTERVAL 2 day) <
j.stellen.t_stellen_date)
but it doesn't work !
What's wrong ?
The t_stellen_date field is a date field !
Thanks