Simultaneous select/update/insert

Posted on 16th Feb 2014 07:03 pm by admin

Hi

How would I need to go about when 2 users update a single row simultaneous? And how would I need to go about when 2 users want to edit a row?

Should I first lock the table, update the row to indicate who is editing the data unlocking the table and selecting the row where the editor_id = the current user_id? Plus what happens when I lock the table do other users get a failed query? and what errno does mysql return in this case?

Do I need to use not null on required fields or should I leave it out?

Your Answer:

Login to answer

Other forums

image upload, resize THEN submit form
Ok so I have a form that requires the user to upload an image, and then do something with that image

MySQL issue
I am taking sentences through a form on page. Then checking some condition and trying to insert them

Adding Different Numbers From MySQL
Basically I have a mysql database with a couple prices as the following:

9.99
9.99
9.99

Pipe email to PHP - get mail adress from MySQL - send?
Hi all,

this is the challenge:

1) Our faculty at the college where I'm employed includ

help with variable
I've got a problem, i want to echo some images depending on the $id, however for me to get that id i

Calander Basic Spript help
hi, just starting out with PHP and have the following script:

<?php
//This gets t

query help
Hi experts.

i have a table rep2 like this
PROD_COD ACCT_NO DUE_DAYS BALANCE

PHP MySQL Return Results Issue
Hi guys,

I'm running joomla and made a module which is using ajax.
Basically i just have a

Unable to display contents in Second Drop Down Box
Hi All,

What I am trying to do is 2 dependent drop down boxes and when user selects su

Need help: how to catch acess of undefined class properties
Hello. I am learning OO with PHP and have hit a problem.
Some code runs as perfectly valid code,