UPDATE incrementally

[xcandiottix]

I have a table that I am using UPDATE when someone creates a post. Is there a way to incrementally increase the table with out loading the value of the field first?

 

Ex:

mysql_query("UPDATE table SET Time='$date' AND Replies++ WHERE Topics='$topic'");

 

The above doesn't work but i'd rather make this work instead of querying the DB for the value, adding one, and then updating.

 

Thanks

[BizLab]

Hey man, long time. You should be able to:

$query = "UPDATE table SET Time='$date' AND replies=replies+1 WHERE Topics='$topic'";

let me know how that works out for ya 

[xcandiottix]

Hey man, long time. You should be able to:

$query = "UPDATE table SET Time='$date' AND replies=replies+1 WHERE Topics='$topic'";

let me know how that works out for ya 

 

I messed you up by accident:

$query = "UPDATE table SET Time='$date',replies=replies+1 WHERE Topics='$topic'";

No AND ..  but yes this worked perfectly... saves me a big headache. Thanks man!

[BizLab]

My bad! I didn't read over the code lol

 

No prob man