Duh found it !
AND ((DATE_SUB('NOW()', INTERVAL 2 day) < 'j.stellen.t_stellen_date')
should be
AND ( (DATE_SUB ('NOW()', INTERVAL 2 day) ) < 'j.stellen.t_stellen_date')
missing close bracket :-))
> On Wednesday 22 May 2002 17:23, John Fishworld wrote:
> > Sorry yes its MySQL
> > yes it was the missing comma causing the problem (thanks)
> > but now I get
> > You have an error in your SQL syntax near 'LIMIT 0, 30' at line 1
>
> > AND ((DATE_SUB(NOW(), INTERVAL 2 day) < j.stellen.t_stellen_date) LIMIT
0,
> > 30
>
> My guess is that you've a missing ')' or an extra '(' somewhere.
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications Development *
>
>
> /*
> It looks like blind screaming hedonism won out.
> */
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
