Her er hele koden, hvor antal alle besøgnge og antal unikke besøgende er det samme, hvilket det ikke skal være... som om distinct ikke fungerer...
<?
include("inc_db_connect.php");
$hentstatistik = mysql_query("SELECT WEEK(tid) AS uge,YEAR(tid) AS aar,COUNT(id) AS antal FROM tblhits GROUP BY YEAR(tid),WEEK(tid) ORDER BY YEAR(tid) DESC,WEEK(tid) DESC") or die(mysql_error());
$hentunikstatistik = mysql_query("SELECT DISTINCT ip,COUNT(id) AS antal,WEEK(tid) AS uge,YEAR(tid) AS aar FROM tblhits GROUP BY YEAR(tid),WEEK(tid) ORDER BY YEAR(tid) DESC,WEEK(tid) DESC") or die(mysql_error());
while($unikstatistik = mysql_fetch_array($hentunikstatistik)) $unikarray[$unikstatistik['aar'].$unikstatistik['uge']] = $unikstatistik['antal'];
?>
<html>
<head>
<LINK rel="stylesheet" href="stylesheet.css" >
</head>
<body topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" marginwidth="0" marginheight="0" bgcolor="#FFFFFF" >
<table border="0" cellspacing="0" cellpadding="0" width="100%" >
<tr>
<td class="mainoverskrift" align="left" width="400" height="50" valign="bottom" ><a href="index.php"><img src="grafik/logo.jpg" border="0" ></a></td>
<td class="main" align="right" valign="bottom" > </td>
</tr>
<tr>
<td align="Left" bgcolor="#8EA0BE" height="17"> </td>
<td align="right" bgcolor="#8EA0BE" > </td>
</tr>
<tr>
<td class="mainsmall" align="Left" > <a href="index.php" >Forside</a> - <a href="varegrupper.php" >Varegrupper</a> - <a href="varedatabase.php" >Varedatabase</a> - <a href="statistik.php" >Statistik</a> - <a href="soegordre.php" >Ordrer</a> - <a href="forside.php" >Forside</a></td>
<td class="mainsmall" align="right"><? echo(date("d. M. Y H:i ",time())); ?> </td>
</tr>
</table>
<!-- template -->
<p align="center" >Frem til 6. april 2007 blev kun unikke besøgende registreret. Fra 7. april registreres alle besøg.<br>
Se også <a href="
http://www.trailerforum.dk/webstat/" >
http://www.trailerforum.dk/webstat/</a> </p><br>
<table border="0" cellspacing="0" cellpadding="0" align="center" >
<tr>
<td class="main" align="left" width="160" colspan="3" style="border-bottom: 1px SOLID #CCCCCC" >Statistik</td>
</tr>
<tr>
<td class="main" align="left" width="80" style="border-bottom: 1px SOLID #CCCCCC" >Uge</td>
<td class="main" align="left" width="40" style="border-bottom: 1px SOLID #CCCCCC" >Alle</td>
<td class="main" align="left" width="40" style="border-bottom: 1px SOLID #CCCCCC" >Unikke</td>
</tr>
<? while($stat = mysql_fetch_array($hentstatistik)) { ?>
<tr>
<td class="main" align="left" width="80" ><? echo$stat['aar']." / ".($stat['uge']+1); ?></td>
<td class="main" align="center" width="40" ><? echo$stat['antal']; ?></td>
<td class="main" align="center" width="40" > - <? //echo$unikarray[$stat['aar'].$stat['uge']]; ?></td>
</tr>
<? } ?>
</table>
</body>
</html>
