Скрипт должен выводить 5 новых и 5 популярных роликов на главной странице:

index.html



index.php

[php]//последние 5 роликов
$sql->Query('SELECT movie.*,user.name as user_nick FROM movie,user WHERE user.id = user_id AND status=0 ORDER BY date DESC LIMIT 5');
$last5movies = array();
if ($sql->error == '' && $sql->NumRows() != 0)
for ($i = 0; $i < $sql->NumRows(); $i++) {
$r = $sql->FetchAssoc();
$r['size'] = convert_size($r['size']);
$r['duration'] = convert_duration($r['duration']);
if ($r['author'] == '') $r['author'] = $r['user_nick'];
$last5movies[] = $r;
}
//лучшие 5 роликов
$sql->Query('SELECT movie.*,user.name as user_nick FROM movie,user WHERE user.id = user_id AND status=0 ORDER BY rating DESC LIMIT 5');
$best5movies = array();
if ($sql->error == '' && $sql->NumRows() != 0)
for ($i = 0; $i < $sql->NumRows(); $i++) {
$r = $sql->FetchAssoc();
$r['size'] = convert_size($r['size']);
$r['duration'] = convert_duration($r['duration']);
if ($r['author'] == '') $r['author'] = $r['user_nick'];
$best5movies[] = $r;
}[/php]