[SOLVED] more simplified way of updating and int with +1 or -1

[scarhand]

trying to simplify this so it uses less lines and 1 query instead of 2:

 

$sql = mysql_query("SELECT views FROM forum_topics WHERE id='$id'");

while ($row = mysql_fetch_array($sql))
{
  $old_views = $row['views'];
  $new_views = $oldviews + 1;
}

mysql_query("UPDATE forum_topics SET views='$new_views' WHERE id='$id'");

 

any way i can make it so this only uses 1 simply query? something kind of like:

 

mysql_query("UPDATE forum_topics SET views='$old_views + 1' WHERE id='$id'");

[scarhand]

Nevermind I got it...

 

mysql_query("UPDATE forum_topics SET views = views +1 WHERE id = '$id'");