Here is the full code for a page I have... please pay attention to the area marked
<?php
include '/www/u/username/htdocs/conn/conn.php';
$gettop = mysql_query("SELECT * FROM movie WHERE list='y' ORDER BY views DESC LIMIT 10",$connm);
$gettray = mysql_query("SELECT * FROM trailers ORDER BY trailerid DESC LIMIT 10",$connm);
$getclip = mysql_query("SELECT * FROM clips ORDER BY clipid DESC LIMIT 5",$connm);
$newsid = $_GET['id'];
$getnews = mysql_query("SELECT * FROM news WHERE newsid='$newsid' LIMIT 1",$conn);
$newscheck = mysql_num_rows($getnews);
$news = mysql_fetch_array($getnews);
//update views LOOK HERE
if($newscheck == 1) {
$views = $news['views'];
$nextview= $views + 1;
$addsql = mysql_query("UPDATE news SET views=$nextview WHERE newsid='$newsid'",$conn);
}
//LOOK ABOVE
//get publisher
if($news['userid'] != "xx") {
$userid = $news['userid'];
$getpub = mysql_query("SELECT * FROM users WHERE userid=$userid LIMIT 1",$user);
$user = mysql_fetch_array($getpub);
}
include '/www/t/themovieguru/htdocs/conn/ads.php';
$description = substr($news['abstract'], 0, 86);
$title2 = "TheMovieGuru.Net- ". $news['title'];
$keywords = $news['keywords'];
?>
The part I am having problem with is the update page views part. When I echo $nextview... it echoes the appropriate number. However, when I look at the table, the number inserted is one higher than $nextview, but it should be $nextview that is updating the row 'views' number.
so:
$views = 10
$nextview = 11
and
table says 12, after updating with $nextview
What the heck?
Thanks
Ryan
