Sql Timer In Php Script

[SpiderWap]

Hi there

Can someone please give me an example:

This is what i want to do, in my builder im coding i want to add the option, site of the week.

The site with the most votes will be on main page for a week, after that week the sql script must automaticly take the site of the site of the week, and put the next site on with highest votes for a week.

If someone could help by giving me an idea it would be nice.

[rukiya]

here is the code

[rukiya]

$t= (7*24*60*60);
$time = time()-$t;

sql = "SELECT MAX(vote) , sitename
FROM `site`
WHERE time>'".$time."'
GROUP BY sitename
LIMIT 1";

[SpiderWap]

mmm, i'll take a look bro thank you very mutch