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 [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of Priyantha Gunawardena Sent: 23 September 2008 01:59 To: php-objects@xxxxxxxxxxxxxxx; phpsrilankans@xxxxxxxxxxxxxxxx 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 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 ***********************************************************************************
