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?

Did you know?Explore Trending and Topic pages for more stories like this.
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?
No comments posted yet

Your Answer:

Login to answer
316 Like 54 Dislike
Previous forums Next forums
Other forums

my login script page is not working on remote computers
hi my login is working on my computer, but when i tried 2 computers from 2 different locations, they

Timer control causing error
I recently decided to add a timer control to an existing page that uses AJAX on my site. As soon as

Using Windows message as a Handle
Hi,

I am writing one of my first multithreaded programs.

In one of the thread,

Connect to database that isn't localhost
I am currently doing a small script for a company that doesn't have mySql support on there hosting.

Schedule editor
Hi,

I have a question related to Schedule editor.
If we schedule a BLS for every 30

Progress bar tracking file downloads
Hey guys, was wondering if there was a way to track how far a file has been downloaded. I know there

New Search Engine problem
Hey everyone,

I have a ZIP Code Radius search engine already functional. it displays all of t

PHP Display Telephone Number On Referrer
I have used the php below to show a different telephone number in the header of the site depending u

Impact of movement type 412 E on MAP
Hi

Usage of movement type 412 E is causing huge change in MAP .

Is there any r

Calling strings from other php class
I have test1.php{
$string1;
$string2;
....
... //10 strings in this class <

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash