RE: [PHP-DB] time field query problems.

2002-07-30 Thread Steve Bradwell
: 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_

Re: [PHP-DB] time field query problems.

2002-07-29 Thread DL Neil
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. >