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

PHP Include not working
The website is http://www.grlistingservices.com

The code block is as follows:

<

how to populate a drop down box
Hi buddies!

PROCEDURE DOWNLOAD_REPORT_FORM (report_name varchar) is begin DOWNLO

Combining Two Queries
I have two scripts that each work fine by themselves. One is a search script with a variable that de

Motivational Posters
Hello,

I wonder how can i do them in php. Are there any sample codes that you can show me?

image upload script not working with png
The basic process of this php code is to take the submitted file, convert it to a small JPG thumbnai

Install page
How do I make it so when a user submits information on the Install page, it'll right it into the cor

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

listing help
Hi,

at first, great new design!!! I like it,

i got a problem,

I want to list so

Trouble checking SESSION cookie
I am trying to use $_SESSION cookies to verify admin privileges .
I don't understand why this is

PHP error on MySQL insert
I'm sure it's the simplest of issues, but I can't recall why this isn't working.

Code: [Selec