Session tracking

[Mick1987]

Hi im trying to track users route through my website. I have managed to get the tracking screen to display the result of which pages they visit. I now want to link the tracking details to my database and display the data from the database relating to the page ids that are selected. There is something wrong with my code however and im struggling with ideas how to do it.

My code is....

<?php
session_start();  

if(isset($_SESSION['Tracking'])){
while (list($key, $val) = each($_SESSION['Tracking'])){
echo "$key -> $val (you visited page id: $val);<br/>" ;

}
$con = mysql_connect("localhost","root","root"); 
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("stories_base", $con);

$result = mysql_query("SELECT * FROM stories_tbl WHERE idnum=$val");

}

if(isset($_SESSION['Tracking'])){   

unset($_SESSION['Tracking']);
}
?>

Any suggestions on where ive gone wrong, or how to correct the code would be welcome....thanks

[djjjozsi]

when a user click on your page, and has the ID from the url.

if $GET["id"] is available:

$_SESSION['Tracking'][]= intval($_GET["id"]);

Then you have a program or site where you need to list the viewed conecnts.

$sql= sprintf("select * from table WHERE id IN (%s) " , implode( $_SESSION['Tracking'] )) ;
echo "test in PHPMYADMIN:" . $sql ;

Alternate way is to directly insert the selected values into a stats table with the userID os sessionid... I would prefer this version.