No error message.I already fixed it,cheers anyway.
Edit:
now i have another problem,
On one page i would like to show the ip adresses and the pages which was accessed by this ips.(its like a static tracker system)
Here is the code
<?php
include "connection.inc.php";
$connection = connect();
$query="SELECT * FROM tracker GROUP BY IP";
$result=mysql_query($query,$connection);
$views=mysql_num_rows($result);
echo $views."Unique IPs<br><br>";
echo "IP views:<br>";
$query="SELECT *,count(*) FROM tracker GROUP BY IP";
$result=mysql_query($query,$connection);
for ($i=0;$i< mysql_num_rows($result);$i++)
{
$IP=mysql_result($result,$i,"IP");
$views=mysql_result($result,$i,"count(*)");
echo"$IP ";
echo "views: $views<br>";
}
echo "<br>Pages views by $IP:<br>";
$query="SELECT *,count(*) FROM tracker WHERE IP = '$IP' GROUP BY page";
$result=mysql_query($query,$connection);
for ($i=0;$i< mysql_num_rows($result);$i++)
{
$page=mysql_result($result,$i,"page");
$views=mysql_result($result,$i,"count(*)");
echo"page: $page views: $views<br> ";
}
echo "<br>Pages views:<br>";
$query="SELECT *,count(*) FROM tracker GROUP BY page";
$result=mysql_query($query,$connection);
for ($i=0;$i< mysql_num_rows($result);$i++)
{
$page=mysql_result($result,$i,"page");
$views=mysql_result($result,$i,"count(*)");
echo"page: $page ";
echo "views: $views<br>";
}
?>