Opdatere et counterfelt
Jeg har et counter felt der skal opdateres når man klikker på en artikel på forsiden. Det er vist noget med at sige + 1 til feltet er det ikke? Jeg har set på de andre spørgsmål omkring det her, men jeg har ikke kunnne få det til at fungere. I får lige lidt kode:Forsiden, hvor jeg tror man skal sætte hits-opdateringskoden ind:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>TheGameViewer :: We view them for you</title>
<meta http-equiv="Page-Enter" content="blendTrans(Duration=1.0)">
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body topmargin="0" leftmargin="0" marginheight="0" marginwidth="0" background="images/main-bg.gif">
<p><img border="0" src="logo_small_gameviewer.JPG" width="301" height="84"><!-- EADS.dk BANNER KODE START --->
<script language="JavaScript">
var now = new Date();
var eadsIndex = now.getTime();
document.write('<s' + 'cript language=javascript1.1 SRC="http://www.eads.dk/getbanner.asp?hsize=60&count=false&id=1955&wsize=468&nocache=' + eadsIndex + '"></s'+'cript>');
</script>
<NOSCRIPT><A HREF=http://www.eads.dk/getbanner.asp?mode=ahref&hsize=60&count=false&id=1955&wsize=468><IMG SRC=http://www.eads.dk/getbanner.asp?mode=img&hsize=60&count=false&id=1955&wsize=468 border=0></A></NOSCRIPT>
</p>
<div id="Menu" style="position:absolute; left:22px; top:148px; width:130px; height:214px; z-index:1; background-color: #ECEFF0; layer-background-color: #ECEFF0; border: 1px none #000000;">
<div align="center" style="width: 130; height: 342">
<p align="center"><strong><font size="2"><u>Menu</u></font></strong></p>
<p align="left"><font size="2"><b>PC<br>
</b><a href="index.asp">Nyheder<br>
</a></font><a href="previews.asp"><font size="2">Previews<br>
</font></a><font size="2"><a href="anmeldelser.asp">Anmeldelser<br>
</a><a href="koder.asp">Koder<br>
</a><a href="screenshot.asp">Screenshots</a></font></p>
<p align="left"><strong><font size="2">Om sitet<br>
</font></strong><font size="2"><a href="index.php">Forside<br>
</a><a href="http://forum.thegameviewer.dk">Forum<br>
</a><a href="om%20os.php">Om os<br>
</a><a href="kontakt.asp">Kontakt<br>
</a><a href="anbefal.asp">Anbefal os<br>
</a><a href="job.asp">Jobs</a></font></p>
<p align="left"><font size="2"><b>Parnere<br>
</b><a href="http://www.ps2planet.dk">Ps2Planet.dk<br>
</a><a href="http://www.realgames.dk">RealGames.dk</a></font></p>
</div>
</div>
<div id="Nyhed1" style="position: absolute; left: 173; top: 148; width: 800; height: 396; z-index: 2; background-color: #ECEFF0; layer-background-color: #ECEFF0; border: 1px none #000000">
<p align="center"><img src="http://www.thegameviewer.dk/TGV3.0/images/Nyheder copy.jpg"></img><br>De 5 seneste nyheder:</p>
<?php
$conn = mysql_connect("server", "user", "pass");
mysql_select_db("database");
$sql = "select * from TGV_stories ORDER BY pn_sid DESC LIMIT 0,5";
$query = mysql_query($sql);
while ($row = mysql_fetch_array($query)) {
extract($row);
echo"
<table class='tekstafsnit' width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td background='images/mainbar.gif'><a href='artikel.php?pn_sid=$pn_sid'><b>$pn_title</b></a> - <font color='#999999'>$pn_time</font></td>
</tr>
<tr>
<td background='images/cellpic1.gif'>Skribent: $pn_informant Hits: $pn_counter
";
if (strlen($pn_bodytext) > 0) {
echo"
<a href='artikel.php?pn_sid=$row[pn_sid]'><b>Læs mere</b></a>
";
}
echo"
</td>
</tr>
<tr>
<td width='100%' height='1' background='images/mainbg.gif'>$pn_hometext<br><br></td></tr>
";
}
mysql_close($conn);
?>
</font>
</div>
</body>
Og siden, artikel.php, hvor nyheden bliver vist. Skal det counterkoden sættes ind i den?:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>TheGameViewer :: We view them for you</title>
<meta http-equiv="Page-Enter" content="blendTrans(Duration=1.0)">
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body topmargin="0" leftmargin="0" marginheight="0" marginwidth="0" background="images/main-bg.gif">
<p><img border="0" src="logo_small_gameviewer.JPG" width="301" height="84"><!-- EADS.dk BANNER KODE START --->
<script language="JavaScript">
var now = new Date();
var eadsIndex = now.getTime();
document.write('<s' + 'cript language=javascript1.1 SRC="http://www.eads.dk/getbanner.asp?hsize=60&count=false&id=1955&wsize=468&nocache=' + eadsIndex + '"></s'+'cript>');
</script>
<NOSCRIPT><A HREF=http://www.eads.dk/getbanner.asp?mode=ahref&hsize=60&count=false&id=1955&wsize=468><IMG SRC=http://www.eads.dk/getbanner.asp?mode=img&hsize=60&count=false&id=1955&wsize=468 border=0></A></NOSCRIPT>
</p>
<div id="Menu" style="position:absolute; left:22px; top:148px; width:130px; height:214px; z-index:1; background-color: #ECEFF0; layer-background-color: #ECEFF0; border: 1px none #000000;">
<div align="center" style="width: 130; height: 342">
<p align="center"><strong><font size="2"><u>Menu</u></font></strong></p>
<p align="left"><font size="2"><b>PC<br>
</b><a href="index.asp">Nyheder<br>
</a></font><a href="previews.asp"><font size="2">Previews<br>
</font></a><font size="2"><a href="anmeldelser.asp">Anmeldelser<br>
</a><a href="koder.asp">Koder<br>
</a><a href="screenshot.asp">Screenshots</a></font></p>
<p align="left"><strong><font size="2">Om sitet<br>
</font></strong><font size="2"><a href="index.php">Forside<br>
</a><a href="http://forum.thegameviewer.dk">Forum<br>
</a><a href="om%20os.asp">Om os<br>
</a><a href="kontakt.asp">Kontakt<br>
</a><a href="anbefal.asp">Anbefal os<br>
</a><a href="job.asp">Jobs</a></font></p>
<p align="left"><font size="2"><b>Parnere<br>
</b><a href="http://www.ps2planet.dk">Ps2Planet.dk<br>
</a><a href="http://www.realgames.dk">RealGames.dk</a></font></p>
</div>
</div>
<div id="Nyhed1" style="position: absolute; left: 173; top: 148; width: 800; height: 396; z-index: 2; background-color: #ECEFF0; layer-background-color: #ECEFF0; border: 1px none #000000">
<?php
$id = $_GET['pn_sid'];
$conn = mysql_connect("server", "user", "pass");
mysql_select_db("database");
$sql = mysql_query("select * from TGV_stories where pn_sid = '$id'");
echo "<table class='tekstafsnit' width='100%' border='0' cellspacing='0' cellpadding='0'>";
while ($row = mysql_fetch_array($sql)) {
extract($row);
$id = $_GET['pn_sid'];
$pn_counter + 1;
if (isset($pn_bodytext)) {
echo"
<tr>
<td width='100%' height='1' background='images/cellpic1.gif'>
$pn_title :
</td>
</tr>
<br>
<td width='100%' height='1' background='images/mainbg.gif'>
$pn_hometext<br>
<br>
<br>
$pn_bodytext<br>
<hr>
</td>
";
}
else {
echo "
<tr>
<td width='100%' height='1' background='images/mainbg.gif'>
$pn_title :<br> $pn_sid[pn_hometext]<br><br>
</td>
</tr>";
}
}
mysql_close($conn);
$conn = mysql_connect("server", "user", "pass");
mysql_select_db("database");
$sql = mysql_query("select * from TGV_comments where pn_sid = '$id'");
echo "<table class='tekstafsnit' width='100%' border='0' cellspacing='0' cellpadding='0'>";
while ($row = mysql_fetch_array($sql)) {
extract($row);
$id = $_GET['pn_sid'];
echo"
<tr>
<td width='100%' height='1' background='images/cellpic1.gif'>
$pn_title | Kommentarer
</td>
</tr>
<tr>
<td width='100%' height='1' background='images/mainbg.gif'>
<p>Kommentarer tilhører den respektive forfatter. Vi fralægger os ethvert ansvar for deres indhold.</p><br>
<br>
</td>
</tr>
";
echo"
<tr>
<td width='100%' height='1' background='images/cellpic1.gif'>
$pn_subject af $pn_name $pn_date
</td>
</tr>
<br>
<td>
$pn_comment
</td>
";
}
mysql_close($conn);
echo "</table>";
?>
</font>
</div>
</body>
</html>
