Updating List

Hawksgames

i have a site with alot of links to different games... and i want them to be organized in the order of the games that are most popular.. and i was wondering if there is a coding or ph r perl thing that would do this for me..

i would like it to update automatically when one link get more clicks than the one above it.. and i would like it to display how many times each link has been clicked..

I kno nothing about the coding of php (all i kno is alot of html) so im gonna need u to explain exactly what i should have.

THANX

bretticus

I kno nothing about the coding of php (all i kno is alot of html) so im gonna need u to explain exactly what i should have.

Wow, I'm not sure anyone is willing to write your code for you. What I'm willing to do is explain what steps you might take and give you some links with syntax and examples.

You will want to use a database of some kind. I assume you're coding on Linux or Windows and you have PHP via Apache or IIS Web servers. You can get MySQL for either. Maybe your site is hosted somewhere with MySQL enabled on your hosting provider's server.

Go to MySQL Docs for more info.

When you get a MySQL database in place, you'll need to create a games table. As one of the fields or columns in your table, make a hits column. Also, besides the usual columns (like the link name), you'll want a URL column for each game record as well. Don't forget that you should make an id column (de facto) that auto increments to ensure all your game records have a unique id.
You really need to read up on For , Loop syntax in the php manual. Because you'll use a while loop (preferribly) with a combination of the MySQL functions of PHP to loop through all your games list and display it in your browser.
As you are looping games to the browser, send all links to a PHP page & tag your link with the database unique id of the game record you are listing (a href="links.php?id=2345"). You can then do an update query to increment your game record hits column and then pull the URL associated with the record and redirect (Header("Location: $URL")😉 to the corresponding URL.
on subsequent page loads of your game list, you'll already have an ORDER BY hits clause in your query. Thus, the more a link is clicked on, the higher in the list it will appear.
DO YOUR HOMEWORK AND READ THE MANUALS. Someday soon this could all make sense. If you don't want to learn, then hire someone.

PHPGuru2

You can store each link in the table with ID and count column.
When a link is clicked, it actually takes you to a page where it updates the count with requested ID, and then launches a new window to take you to the actual page.

1) <a href="jump.php?link_id=1">http://www.game.com/</a>
2) jump.php will look into the table in the database where link_id is equal to 1. If the record is found, then it updates the count, and then redirect you to the actual page (http://www.game.com).

When you actually display links in the page, you can run a select query order by count in decending order (from largest to smallest) and print them out. That's all you have to do.

My advice, if you don't know anything about PHP (or any other programming language) then you really need to go get the book. You have to have at least some kind of programming background (at least the basics) in order to understand how it can be done. There are just too much to write in here and people probably won't help you without you actually write your own code (They won't write the code for you.)

Good luck bro.

Well, bretticus has already posted a same thing before I did.