Re: Re[2]: [PHP-DB] Table locking

2004-07-15 Thread emre erdogan
Hi... I want to say some words about the Table Locking problem. I had a problem something like this one, I find solution for this by locking only the item that will updated. I added two areas one that has a value 0 or 1 giving it is currently used by someone, and second time it is started to

Re: Re[2]: [PHP-DB] Table locking

2004-07-15 Thread Tim Van Wassenhove
In article [EMAIL PROTECTED], Emre Erdogan wrote: Hi... I want to say some words about the Table Locking problem. I had a problem something like this one, I find solution for this by locking only the item that will updated. I added two areas one that has a value 0 or 1 giving it is

Re: [PHP-DB] Table locking

2004-07-10 Thread Rosen
I need to be sure, thath nobody else will can write on some tables until I don't append obout 4-500 records in these tables. But until now I never used table locking in MySQL and I didn't found information about this ( like examples ). Is there a problem with locking if PHP uses same userpass for

Re: [PHP-DB] Table locking

2004-07-10 Thread Rosen
I have an orders with one main record in table1 ( client, date, e.t.c. ) and detail description in table2 ( all materials with quant, price, e.t.c. ) and I save data in table1 for positions (range of id - autoinc field of records in table2) for detailed data of order . And I don't want someone

Re: [PHP-DB] table locking ... not required ?

2004-07-09 Thread Torsten Roehr
John W. Holmes [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Michael Gale wrote: For the UPDATES ... what would have it in theory two people hit the UPDATE button at the exact same time ? Would one just over write the other ... cause that is fine ? Hi Michael, is it really OK

Re: [PHP-DB] table locking ... not required ?

2004-07-09 Thread Michael Gale
Yes .. it is ok - the data that I allow to get updated like this is not that important and when a update is made it would be two people entering the same data anyways. It is just for contact info for people in the db ... like there current phone or address if it changes. Michael. On Fri, 9

[PHP-DB] Table locking

2004-07-08 Thread Rosen
Hi, I have the following situation: I have to prevent users to write at the same time in one table in PHP script. Is there a way the PHP to understand, thath another user is filling table, and to wait before begin to fill data? Thanks in advance! -- PHP Database Mailing List

Re: [PHP-DB] Table locking

2004-07-08 Thread John W. Holmes
Rosen wrote: I have the following situation: I have to prevent users to write at the same time in one table in PHP script. Is there a way the PHP to understand, thath another user is filling table, and to wait before begin to fill data? Most databases have a LOCK command that you can issue. The

Re: [PHP-DB] Table locking

2004-07-08 Thread Rosen
Is thath mean, thath, when one user is addind records to table, and lock it - when another user is trying to get the max field value for some field, the script will waiting the first user to unlock table and then to see the max value of some field in a table ? John W. Holmes [EMAIL PROTECTED]

Re: [PHP-DB] Table locking

2004-07-08 Thread Jason Wong
On Friday 09 July 2004 07:09, Rosen wrote: Is thath mean, thath, when one user is addind records to table, and lock it - when another user is trying to get the max field value for some field, the script will waiting the first user to unlock table and then to see the max value of some field in

Re: [PHP-DB] Table locking

2004-07-08 Thread Rosen
Thanks, but can you give me a sample PHP script with MySQL database, whitch do this? Thanks Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Friday 09 July 2004 07:09, Rosen wrote: Is thath mean, thath, when one user is addind records to table, and lock it - when

Re: [PHP-DB] Table locking

2004-07-08 Thread Rosen
And if I perform LOCK tables ... nobody can;t write on these tables, until I don't perform UNLOCK TABLES ? If something happens ( I mean if some my queryes fails) ? Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Friday 09 July 2004 07:24, Rosen wrote: Thanks, but can

RE: [PHP-DB] Table locking to prevent duplicate inserts?

2003-10-21 Thread Mayo, Chuck
and will incorporate your suggestions into my work in the future. Chuck -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 11:32 AM To: Mayo, Chuck Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Table locking to prevent duplicate inserts

[PHP-DB] Table locking to prevent duplicate inserts?

2003-10-20 Thread Mayo, Chuck
Hi all, Hope you'll forgive the duplicate post but the list seems to be hopping today (unlike the friday afternoon I sent the original query)... since everyone seems to be awake today I thought I'd try it again: --- I'm working through an issue that I'm sure everyone else has

Re: [PHP-DB] Table locking to prevent duplicate inserts?

2003-10-20 Thread John W. Holmes
Mayo, Chuck wrote: Hi all, Hope you'll forgive the duplicate post but the list seems to be hopping today (unlike the friday afternoon I sent the original query)... since everyone seems to be awake today I thought I'd try it again: Sorry about that; I hate to keep my employers waiting. BTW, I

[PHP-DB] Table locking to prevent duplicate inserts?

2003-10-10 Thread Mayo, Chuck
Hi all, I'm working through an issue that I'm sure everyone else has already figured out, how to lock a table during a series of INSERTS to prevent duplicate entries: The scenario is this: OS Solaris 8 PHP 4.2.3 MySQL 3.23.53 Table type: MyISAM 1) A user submits a form containing about

[PHP-DB] Table Locking...

2001-11-21 Thread Ashley M. Kirchner
(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? I don't care for locking while using SELECTs, but I do need locking when something's being INSERTed or UPDATEd, so I won't get two