I Want A Php Code To Display The Most Popular...

I want a PHP code to display the most popular clicks/links on certain pages.

Can anyone help?

you need to create a counter database for each url
in your site
increment each time (using php)
then create the stats

virrey is right on. Think about added code to the top of each of the pages you wish to track. The query could insert $PHP_SELF into a page column, giving you a row for each page load.

Alternately you could set up another field as "hits" and then do a query to see if a row for that page is already in the database. If it is, use UPDATE, if not, INSERT.

Eventually when MySQL 4.1 goes from Gamma release to General, you will be able to use "INSERT... ON DUPLICATE KEY SET..." which will let the database decide whether to update or insert.

You need a counter to track the clicks.

There are 3 ways to do this.

One is shared memory. Reference http://ca.php.net/manual/en/function.shm-attach.php

One is files. You track the count in your file. Be care of the synchronize problem.
the process should be:

<?
fopen()
flock(LOCK_EX)
fread()
count++
fwrite()
flock(LOCK_UN)
fclose()

?>

One is database. You save the click to database.

or, in the full code, it will be just like this:

create an database table whit the following rows:
-id
-name
-clicks

and an page called link.php:



Now, you just need to fill the database with your areas and change all links. If the link was games.htm, it will be link.php?ref=games
That's all :] if the script doesn't run, post again and I'll fix the problems.

i've forgot... just completing.
to display the most popular in tables, just write this code:

show.php



that's all! You know, if this script doesn't run, post here and I'll fix it. And don't forget to conect whit the database in the top of this page. If u don't know how, just look at my other post. There is an example. I hope I've helped you! \_

FaLgoR thanx for the tip man that will be very useful