Hi Hayan,
have a look at: http://www.mysql.com/doc/L/O/LOCK_TABLES.html for information on (un)locking tables. At 11:48 28.01.02 +0300, you wrote: >Hi, Is there a way to lock a table so that only one user can change it and >then unlockit? >I need to do this coz I want visitors to retrieve some values from a >database but each value must be retrieved only by one user and then marked >up to be expired, so I don't want two users to retrieve the same value >Any suggestions > >Best Regards >Hayan > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php urbia Grüße - best regards Tobias Kremer Webmaster / Software-Entwicklung urbia.com AG Hohe Str.115, 50667 Köln tel: +49 (0)221 - 2949 154 fax: +49 (0)221 - 2949 599 e-mail: [EMAIL PROTECTED] http://www.urbia.de - we are family http://www.urbia.fr - votre espace famille http://www.urbia.co.uk - the family site "Linux is like a wigwam. No gates, no windows but an apache inside" --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
