Database Top Site

[Dihan22]

Hi peeps

I want to create a top site similar to www.styleboost.com

It probably works through a admin and a database system (MySQL)

anyone know how I can get started on this.

The main area that I would like to know is like styleboost, When a new subject is inserted the rest would move down and to another page. How is that done ?

That site uses asp but I rather use php and MySql.

Thanks for you time.

D

[cgraz]

well they're ordered by date or id. so your query would look something like

SELECT * FROM table ORDER BY id

or ORDER BY date

etc.

If you want top sites, what you'd do is create a field in your database called something like top_site or whatever, then keep track of the clicks and add one each time the site is visited so the database is updated, then you'd do a select but order by top_site descending (from greatest to least)

SELECT * FROM table ORDER BY top_site DESC

Cgraz