I'm not sure if it's atomic, but (AFAIK) you can do something like this with Mysql:
UPDATE table SET field=field+1 where ..... --- Scott Hurring Systems Programmer EAC Corporation [EMAIL PROTECTED] Voice: 201-462-2149 Fax: 201-288-1515 > -----Original Message----- > From: J Smith [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 27, 2002 12:49 PM > To: [EMAIL PROTECTED] > Subject: [PHP] Re: Thread safe > > > > You could use a transaction block if your database supports > it, or just use > some sort of auto-numbering field, such as SERIAL in Postgres, > auto_increment in MySQL, etc. Then you wouldn't have to worry about > retrieving the next cno before inserting a new row. > > J > > > R wrote: > > > Hi, > > In java servlets I used to use a "synchronised" block of > code to make > sure > > it was thread safe...how do i do this in PHP? > > > > Heres what should be thread safe > > > > { > > $r=select max(cno)+1 from MyTable; > > (then i insert into the table the new cno plus my name) > > insert into mytable ($r,'myname'); > > } > > How to do this and make sure its thread safe? > > > > Any help appreciated, > > -Ryan > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
