php tracker system

[mr_jodete]

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>";
}
?>

Can anyone help please?

 

[Starshine]

You have multiple threads open asking the same thing. Please keep this to one forum area.
Continued abuse of our forums will result in an infraction or temp-ban of your account.