[djnaf]

hello
i'm trying to put a top 10 pages viewed in my website
supose its a joke site
the jokes is saved in MySQL, and there is a coloum in the table called counter, when ever a joke is viewed the counter increase one.

i thought of making a for loop to to sort the jokes according to the most viewed joke, and then display a TOP 10 table.

but i didnt know how to do it, how to display the top 10.
or if there is another way to do this.

i hope you can help me people

[djnaf]

Originally Posted by djnaf

hello
i'm trying to put a top 10 pages viewed in my website
supose its a joke site
the jokes is saved in MySQL, and there is a coloum in the table called counter, when ever a joke is viewed the counter increase one.

i thought of making a for loop to to sort the jokes according to the most viewed joke, and then display a TOP 10 table.

but i didnt know how to do it, how to display the top 10.
or if there is another way to do this.

i hope you can help me people

Why no one interested!!!!

[altlprsn]

I am interested, unfortunately I can't help you...

Good luck...

[NeverMind]

to do this, use ORDER BY..
so this how the SQL query should look:

Code:

SELECT * FROM jokes ORDER BY counter DESC LIMIT 10;

change 'counter' to the column name you have!

this query should fetch 10 jokes sorted desceding by counter..

Why no one interested!!!!

chill out!
help isn't always avilable in the same day of posting the problem

[Klesti]

use this code:

PHP Code:

$sql = "SELECT * FROM jokes ORDER BY counter DESC LIMIT 10";

$result = mysql_query($sql);

while ($row = mysql_fetch_assoc($result)) {

//put here the displaying link code

}