complex listing

[mediamind]

Hi all,

I would like to have a list of all users (sofar so good) and of aal the pages they visited on the site.

I'm using the code below to get the list of user id's this works fine but inside this list i need another list of all the pages they visited... i just can't figure it out, so i'm asking you guy's help ...

Any idea's?

Kind regards,
Gerry

<pre>
$sql = mysql_query("SELECT tracking_id, COUNT(tracking_id) AS cnt FROM track_user WHERE DATE_FORMAT(time_stamp,'%e') = '27' GROUP BY tracking_id ORDER BY cnt DESC");
$num = mysql_num_rows($sql);
if ($num !=0) {
while ($row=mysql_fetch_array($sql)) {

					echo "<tr valign=top><td class=\"body9-zwart\">" . $row["cnt"] . "</td>";
					echo "<td class=\"body9-zwart\">" . $row["tracking_id"] . "&nbsp;";
					echo "<li> // pages //";
					echo "</td></tr>";
					}

			} else {
				echo "<tr><td colspan=2 class=\"body9-zwart\">NO DATA</td></tr>";
			}

</pre>

[quicknik]

Hi,

why don't use something like :

$list= array(
'id1' => array('page1','page2'...),
'id2' => array('page3)
);