On Wednesday 22 May 2002 16:51, John Fishworld wrote:
> Can someone help me with the correct sytax here !
Please state which DB you're using. I assume it's MySQL.
> I'm trying to show results from the last two days(or week etc)
> This is what I've got
> SELECT .....
> AND ( (DATE_SUB(j.stellen.t_stellen_date INTERVAL 2 day) <
> but it doesn't work !
Please state /how/ it doesn't work!
> What's wrong ?
You're probably missing a comma before INTERVAL, and you're using the wrong
AND ((DATE_SUB(NOW(), INTERVAL 2 day) < j.stellen.t_stellen_date) ...
> The t_stellen_date field is a date field !
Ok, we can hear you loud and clear, no need for the exclamation marks :)
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
Why do they call it baby-SITTING when all you do is run after them?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php