Re: Get Confused : Use Transaction or not
| From: | Justin Patrin | Date: | Mon, 25 Apr 2005 16:32:34 +0000 |
| Subject: | Re: Get Confused : Use Transaction or not | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-18948@lists.php.net to get a copy of this message | ||
On 4/25/05, Phil <phil.cyc@msa.hinet.net> wrote:
> Hi,
>
> I want to develop a multiuser system using PHP(5.04),MySQL(4.1.10) and
> PEAR(DataObject).
> There is only one MySQL account for PHP to operate data.
> All user's information will be stored in database,include id,passwd and etc.
> However,I get confused when I write queries in PHP script.
> Because one data row may be modified by different user at the same time.
>
> Should I use Transaction in my queries ?
>
This would be better suited to a database list.
If you're worried about multiple users editing the same record you
should probably use a DB system which allows record locking.
--
Justin Patrin