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

str_replace help
I am thinking str_replace is my only option to filter outputs from my database to convert them to sa

New Login Script
Hi all, i attempted to create a whole new login script witch isnt working for some reason i dont kno

Mail form doesn't send Russian/Cyrillic characters correctly?
When someone enters foreign characters (like Cyrillic text, and Japanese/Chinese probably gives the

Code working in IE but not FireFox
I created a dynamic navigation list for my website based off of a table in my database. The code is

Displaying image pathname instead of image
Hello

Im trying to upload and then display images from a mysql database - Its only basic and

Mysql query, two times?
Hello to all,

I'm new to php coding and i like it alot. I need help with some noob stuff.

simple php table loop
Hi all,

I've the following code

<?php // Create category options

Different payment methods with different cross company requirements in F110
We are implementing SAP in a company in the shipping industry. They have the following requirement:<

PHP Blog help
Need help with posting comments in a word press blog? I have a comments page where the comments are

Question about the upload of large files
Hi there,

I have a question about the upload of large files, like videos (files generally abo