Hello guys,
I have a simple script which counts how many pageviews my newsitems have:
[php]// Page ID
$page = $row[id];
$result = mysql_query(“SELECT page_count FROM view WHERE page_id = $page”);
$t_count = mysql_num_rows($result);
if($t_count > 0){
$cnt = mysql_result($result, 0, ‘page_count’);
$cnt++;
mysql_query(“UPDATE view SET page_count = $cnt WHERE page_id = $page”);
}else{
mysql_query(“INSERT INTO view ( page_id , page_count ) VALUES ($page, ‘1’)”);
$cnt = 1;
}
// echo the number of hits
echo “Pageviews: $cnt”;[/php]
When I go to phpmyadmin, I can just click on “page_count” to sort my newsitems, most viewed newsitem on top.
But does anyone know how I can do the same thing in PHP, so I can add the 10 most viewed newsitems on my website.
Thank you for your help.