: Re: [PHP-DB] time field query problems.
Steve,
> 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;
>
> -EDIT_
Steve,
> 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;
>
> -EDIT_LOCK is a MySQL (ver 3.23.49-max) time field, allows nulls, default
is
> NULL.
>
, July 29, 2002 3:13 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] time field query problems.
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 anyon
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