Как да направя по 3 клипа на ред ?
Ето как е сега - http://video.sait4e.info/video.php
Ето го кода
Ето как е сега - http://video.sait4e.info/video.php
Ето го кода
Код:
<?php include("header.php"); ?>
<?php
include_once "config.php";
echo '<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">';
if(!isset($_GET['page']))
{
$page = 1;
}
else
{
$page = $_GET['page'];
}
echo " ";
echo "<tr>";
$max_results = 9;
$from = (($page * $max_results) - $max_results);
// старт
$mysql = mysql_query("SELECT * FROM clips ORDER BY id DESC LIMIT $from, $max_results");
echo"<table border=\"2\" width=\"300\" cellspacing=\"5\" align=\"center\"><tr>";
while($r = mysql_fetch_array($mysql))
{
$vid=$r['id'];
$title=$r['ime'];
$pic=$r['pic'];
if($pic != null)
{
echo "<td><center><a href='view.php?id=$vid' title='$title'><img src='$pic' border='0' alt='$title' width='120' height='90'></a></center></td>";
$i++;
}
else
{
echo "<td><center><a href='view.php?id=$vid' title='$title'><img src='no.jpg' border='0' alt='$title'></a></center></td>";
$i++;
}
if($i > 4)
{
echo"</tr><tr>";$i = "0";
}
}
echo"</tr></table>";
echo "<br>";
echo "<center>Страници: ";
// стоп
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM clips"),0);
$total_pages = ceil($total_results / $max_results);
if($page > 1){
$prev = ($page - 1);
echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"></a> ";
}
for($i = 1; $i <= $total_pages; $i++){
if(($page) == $i){
echo "$i ";
} else {
echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> ";
}
}
if($page < $total_pages){
$next = ($page + 1);
echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next\"></a>";
}
echo "</center>";
?>
<?php include("footer.php"); ?>
