Thanks buddy this is what i wanted http://www.phpbuilder.com/board/archive/index.php/t-10256081.html read this as well regards Priyantha On Tue, Sep 23, 2008 at 1:33 PM, Atkinson, Robert <ratkinson@xxxxxxxxxxxxx>wrote: > You need to explain what you mean by concurrent access. > > To me, this means only allowing a specific number of users to access the > system at any one time. As one logs out, another can then log in. > > If you're talking about access to the data itself, then MySQL supports > Transactions > (http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-transactions.html), so > you > should be able to use that technique to update all the relevant tables in a > single hit. > > If possible, you should try and design your application and database so > that > it looks after itself. Perhaps use a temporary table that holds updates > that > need to be applied to the data, and before anything can be read from the > database, the table has to be empty? > > Rob. > > > -----Original Message----- > From: php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com> [mailto: > php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com>] On > Behalf Of Priyantha Gunawardena > Sent: 23 September 2008 01:59 > To: php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com>; > phpsrilankans@xxxxxxxxxxxxxxxx <phpsrilankans%40googlegroups.com> > Subject: Concurrent Access with PHP / MYSQL > > Hi All Pals > > Can anyone explain how we can manage concurrent access in PHP with MySQL. > Did anyone use this is practice? > > Regards > -- > Priyantha Gunawardena > ______________________________________ > {Web Designer / Developer} > Tel: +94 038-228-4323 > Mobi: +94 077-393-8516 > Blog: http://www.pgdesigning.com > IM : pgdesigning > > [Non-text portions of this message have been removed] > > ------------------------------------ > > Are you looking for a PHP job? Join the PHP Professionals directory Now! > http://www.phpclasses.org/professionals/Yahoo! Groups Links > > > *********************************************************************************** > Any opinions expressed in email are those of the individual and not > necessarily those of the company. This email and any files transmitted with > it are confidential and solely for the use of the intended recipient > or entity to whom they are addressed. It may contain material protected by > attorney-client privilege. If you are not the intended recipient, or a > person responsible for delivering to the intended recipient, be advised that > you have received this email in error and that any use is strictly > prohibited. > > Random House Group + 44 (0) 20 7840 8400 > http://www.randomhouse.co.uk > http://www.booksattransworld.co.uk > http://www.kidsatrandomhouse.co.uk > Generic email address - enquiries@xxxxxxxxxxxxxxxxx<enquiries%40randomhouse.co.uk> > > Name & Registered Office: > THE RANDOM HOUSE GROUP LIMITED > 20 VAUXHALL BRIDGE ROAD > LONDON > SW1V 2SA > Random House Group Ltd is registered in the United Kingdom with company No. > 00954009, VAT number 102838980 > > *********************************************************************************** > > > -- Priyantha Gunawardena ______________________________________ {Web Designer / Developer} Tel: +94 038-228-4323 Mobi: +94 077-393-8516 Blog: http://www.pgdesigning.com IM : pgdesigning [Non-text portions of this message have been removed]
