[PHP-DB] Re: Connection closing problem!

2001-02-10 Thread Benjamin Pflugmann
Hi. It looks like you are using persistent connections with SQL server, but not with MySQL (time_wait and close_wait are states of a TCP connection after it was closed by the appliction). I don't know much about PHP, but there is somewhere a option to influence whether you want persistent

[PHP-DB] Re: Table Locking...

2001-11-27 Thread Benjamin Pflugmann
Hi. Please stop cross-posting and use the appropriate forum. On Wed, Nov 21, 2001 at 03:27:23PM -0700, [EMAIL PROTECTED] wrote: (PHP-DB folks, ignore this top question - unless you want to answer) Which type of DB/Table provides table locking while a process is altering data?

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

2002-07-29 Thread Benjamin Pflugmann
Hi. On Mon 2002-07-29 at 14:41:30 -0400, [EMAIL PROTECTED] wrote: Sorry to repost but I typed in the wrong sql statement in my previous post. Ah. Okay. For some reason the below statement is not working. Can anyone tell me why? Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL 10