Code to increase the value of a DB field by 1

[lorddraco98]

I'm writing some forum software. One of the features is view/reply counts for threads and forums. So when someone click on a link to a thread, I want it to submit a query that increases the value of the DB field views by 1.
With php I would just do $views++, but what code do I use in my sql query to achieve the same thing??
Thanks!

[mmcdermo_php]

First you need to get the value of the $views variable, be it from a file or DB. Then you can use $views++ to increase it by one. After that, you could use this to add it to the DB after you have connected to the database:

$query="INSERT INTO $table (views) VALUES ('$views')";
mysql_query($query);

I think that'll work.....

[swon]

If I understood you correctly you are searching for the update-statement:

<?
// in the query before, you get the old views value; then
$views++;
// then you update the views value by;
$query = "UPDATE yourtable SET views='$views' WHERE id = '$id'";
mysql_query($query);
?>

[MeX]

hi mmcdermo_php!!

let mysql do the job:

$query = "UPDATE table_name SET views = (views + 1) WHERE id = '$id'":
$result = mysql_query($query);

hope that helps!!

ceeyaa.MeX