[nycphp-talk] Re: semaphores on Windows

Emmanuel. M. Decarie emm at
Tue Mar 11 11:08:14 EST 2003

Hello Ophir, thanks for the reply.

Its really basic stuff. A Flash file will send via POST to a PHP 
script some text. I need to insert the text in MySQL in a row which 
have an auto_increment column. I want to keep only the last 10 text, 
so I will query MySQL to get all the text, and if I have more than 10 
texts, I will delete the older ones.


À (At) 09:53 -0500 11/03/03, Ophir Prusak écrivait (wrote) :
>Can you describe the situation in a bit more detail ?
>As you said - you probably don't need semaphores, but what is it exactly
>that you're trying to do ...
>----- Original Message -----
>From: "Emmanuel. M. Decarie" <emm at>
>To: "NYPHP Talk" <talk at>
>Sent: Tuesday, March 11, 2003 9:27 AM
>Subject: [nycphp-talk] Re: semaphores on Windows
>>  I forgot to add  that I need semaphores for INSERT and DELETE sql
>>  statement for MySQL. Maybe this is not needed after all. The rows
>>  that are concerned are using a column with an AUTO_INCREMENT
>>  attribute.
>>  I don't need rollback (i.e. transaction). In its book on MySQL, Paul
>>  Dubois write: "MySQL automatically performs locking for single SQL
>>  statements to keep clients from interfering with each other." (Paul
>  > Dubois, MySQL, New Riders, 2000).

Emmanuel Décarie / Programmation pour le Web - Programming for the Web
Radio UserLand/Frontier - Perl - PHP - Javascript  <>
Blog: <> - AIM: scriptdigital

More information about the talk mailing list