Search found 3 matches

by jbrzezniak
Sat Apr 16, 2005 6:27 pm
Forum: Databases
Topic: Preventing scripts from simultaneously accessing a table
Replies: 5
Views: 546

I'm using innoDB now and everything is working fine.
Thanks! :D
by jbrzezniak
Sat Apr 16, 2005 9:13 am
Forum: Databases
Topic: Preventing scripts from simultaneously accessing a table
Replies: 5
Views: 546

Okay, here's an example code, although it's a bit abstract (but I think it shows the problem clearly): $result = mysql_query ("SELECT * FROM table;"); $assoc = mysql_fetch_assoc ($result); $value = $assoc ["value"]; $newValue = $value + 1; // this loop is simply to give me enough...
by jbrzezniak
Fri Apr 15, 2005 4:57 pm
Forum: Databases
Topic: Preventing scripts from simultaneously accessing a table
Replies: 5
Views: 546

Preventing scripts from simultaneously accessing a table

Hello I use MySQL and I have a problem with my script. First I obtain some data from a table (with a SELECT query) then I do something with it and update the field the data was taken from (with an UPDATE query). It works fine as long as the script is not run twice almost at the same time, because th...