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

Apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?

TimeZoneOffset
Hello,

Please i need your help. I have a system that users can use to punch in and out. This

Custom Container in module pool program
Hello everyone,

I have created a custom control in my module pool screen. Now I want to s

php include email form with attachment
I have had no luck with finding a email form all over the Internet for various reasons. Some insecur

getting most records by count
Code: [Select]<?php

$connect = mysql_connect("localhost","dam

Change snippet to use CURDATE
I am using time() in the snippet below, I would like to use CURDATE() and have the database setup fo

how to validate date using javascript
I need to validate date in textbox using javascript..
The date is must be not greater than TODAY

Array becomes unset by itself?
Hi,

I have a bit of experience with PHP but not extensive. It seems I cannot store any items

LinkedList help
Ok so I just learned quickly about lists, so I have a not too hard project I think, but am having a

FlashVar function how to insert variables
Hi guys. Im new in this forum and also new in php programming. Can you help me about this code?
<

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