The number from $views is not getting put into the database like it should do i need to do something with the update function?PHP Code:<?
$id=$_GET['id'];
$conn = mysql_connect("freelinuxhost.com","XXXXXXX","XXXXXXX");
$db = mysql_select_db("XXXXXXX");
$query = "SELECT * FROM `forum` where id='$id';";
$results = mysql_query($query);
$rows = mysql_fetch_array($results);
if($id != ''){
print "<table class=itext3 width=75%><tr><td><b> Topic:</b>";
echo $rows['topic'];
print "</td></tr><tr><td><b>Username:</b>";
echo $rows['username'];
print"</td></tr>";
print"<tr><td><b>Message:<br></b>";
echo $rows['message'];
print"</td></tr></table>";
$views= $rows['views']+1;
$result="UPDATE forum SET views='$views' WHERE id='$id'";}
if($id == ''){
print"<b>ERROR</b>-No Message Selected!";} ?>
[EDIT] nevermind


Reply With Quote
Bookmarks