well ive nearly finished the forums part of the new script im coding
but i have come across a small bug
what i am trying to acheive here is forum_latest gets updated with the file a user clicks on forum posts and it updates the user name as to create a list of whos viewed like here on coding talk.but whats happening is with the code it inserts just the one user it doesnt update the list can anyone shed some light on this error. ive tried UPDATE AND INSERT as well
but i have come across a small bug
PHP Code:
<?php
$dbname = "test";
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
//////////////////////////////////////////
$conms = mysql_connect($dbhost,$dbuser,$dbpass);
$condb = mysql_select_db($dbname);
include("core.php");
session_name("PHPSESSID");
session_start();
$sid = $_SESSION['sid'];
$uid = getuid_sid($sid);
$tid = $_GET["tid"];
$fid = $_GET["fid"];
$pid = $_GET["pid"];
$go = $_GET["go"];
$nick = $_GET["nick"];
$curr=$uid;
$nick=getnick_uid($curr);
$vtime = time();
$unick = getnick_uid($uid);
$dnt = mysql_fetch_array(mysql_query("SELECT filename, dcount FROM ibwf_posts WHERE id='".$tid."'"));
$hit = $dnt[1] + 1;
mysql_query("Update forum_latest SET id='".$tid."', name='".$nick."', tid='".$tid."'");
mysql_query("UPDATE ibwf_posts SET dcount='".$hit."' WHERE id='".$tid."'");
header("Location:fattach/$dnt[0]");
?>
Comment