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