On Tuesday 30 July 2002 02:41, Steve Bradwell wrote:
> Sorry to repost but I typed in the wrong sql statement in my previous post.
>
> For some reason the below statement is not working. Can anyone tell me why?
>
> Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL 10 MINUTE <
> now() AND ORDER_NO = '5' AND EDIT_LOCK > 0;

I think you have to use something like:

  ... WHERE DATE_ADD(EDIT_LOCK, ...) < ...

Check manual for details.

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *


/*
Intuition, however illogical, is recognized as a command prerogative.
                -- Kirk, "Obsession", stardate 3620.7
*/


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

Reply via email to