Read, Modify, Write in one operation

[Hodo]

I want to change a value in a field. It is just a counter so I need to read the data add one then write it back or is there a simple way to do it?

 

$query = "SELECT * FROM Tracks where id = '$id'";

if (mysql_num_rows($result) > 0)

{

while($row = mysql_fetch_row($result))

{

$row[1]++;    <<< WILL SOMETHING LIKE THIS WORK?

}

}

[Illusion]

Update tracks set id=id+1 where id='$id';

[fenway]

*shudder*

 

I'll pretend that you're not really trying to change the ID.

 

And then I'll pretend that you don't care if it's thread-safe or not.

[Illusion]

*shudder*

 

I'll pretend that you're not really trying to change the ID.

 

And then I'll pretend that you don't care if it's thread-safe or not.

is these words are pointing to me

[fenway]

*shudder*

 

I'll pretend that you're not really trying to change the ID.

 

And then I'll pretend that you don't care if it's thread-safe or not.

is these words are pointing to me

 

Sort of ;-) Obviously, IDs never change; and for certain counters, you need to make sure the number is up-to-date across all threads.