как да направя ...

[bobo12]

как да напрявя примерно на определн брои клипчета дами прави страница ето кода

<? 
include"conf.php"; 
$pp = "5"; 
//клипчета на страница 
$table = "clips"; 

$total = mysql_result(mysql_query("SELECT COUNT(id) FROM $table "),0); 
$numofpages = $total / $pp; 
if (!isset($_GET['page'])) { 
$page = 1; 
} 
else { 
$page = $_GET['page']; 
} 
$limitvalue = $page * $pp - ($pp); 


echo"<table align=\"left\" border=\"0\">"; 

$i="0"; 
$nared="6"; 
$query="SELECT * FROM $table ORDER BY id"; 
$result=mysql_query($query); 
while ( $r = mysql_fetch_array( $result )){ 
$i++; 
$width=ceil(100/$nared); 
$ime=$r[ime]; 
$pic=$r[pic]; 
$klik=$r[klik]; 
$url=$r[url]; 
if (strlen($ime)>16) 
{$t='...';} 
$ime = substr($ime,0,16); 
$kat = $r[kategoria]; 
echo"<td width=\"130\" align=\"center\" border=\"1\" background=\"images/b.gif\"> 
<a href=\"view.php?id=$r[id]\" onmouseover=\"return overlib('$r[ime]')\" onmouseout=\"return nd();\"><img src=\"$pic\" border=\"0\" width=\"120\" height=\"90\"></div><br><b>$ime$t</a>"; 
if($kat==""){ 
echo"<br>Гледан : $klik пъти 
<br>Свали : <a href=\"$url\">От Тук</a> 
<br>Няма категория<br>"; 
}else{ echo" 
<br>Гледан : $klik пъти 
<br>Свали : <a href=\"$url\">От Тук</a> 
<br>Категория : <a href=\"cat.php?kategoria=$r[kategoria]\"><b>$kat</a><br>";} 
if ($i==$nared) 
{ 
echo "</tr> 
<tr>"; 
$i=0; 
} 
} 
echo"</table>"; ?>

 

[shaxaaa]

<?php
$rowsPerPage = 10;
$pageNum = 1;
$pagelinks = "<div align=\"center\">";

if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$self = $_SERVER['PHP_SELF'] . "?" .
$_SERVER['QUERY_STRING'];
$self = str_replace("&page=".$pageNum,"",$self);
$offset = ($pageNum - 1) * $rowsPerPage;

//тука изведи каквото ти трябва
$primer = mysql_query("SELECT * FROM primer WHERE primer=1 DESC LIMIT $offset, $rowsPerPage")
or die(mysql_error());
while ($rows = mysql_fetch_array($primer)) {
extract($rows);
echo "тука таблицата в която да се изведат";
}


$query = "SELECT COUNT(*) AS numrows FROM primer WHERE primer=1";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];

if ($numrows > $rowsPerPage) {
if($pageNum == 1){
$pagelinks .= "<span class=\"pageprevdead\">< Предишна</span>";
}else{
$pageprev = $pageNum - 1;
$pagelinks .= "<a class=\"pageprevlink\" href=\"" . $self .
"&page=" . $pageprev . "\">< Предишна</a>";
}

$numofpages = ceil($numrows / $rowsPerPage);
$range = $admin['pageRange']['value'];
if ($range == "" or $range == 0) $range = 7;
$lrange = max(1,$pageNum-(($range-1)/2));
$rrange = min($numofpages,$pageNum+(($range-1)/2));
if (($rrange - $lrange) < ($range - 1)) {
if ($lrange == 1) {
$rrange = min($lrange + ($range-1), $numofpages);
} else {
$lrange = max($rrange - ($range-1), 0);
}
}

if ($lrange > 1) {
$pagelinks .= "..";
} else {
$pagelinks .= "  ";
}
for($i = 1; $i <= $numofpages; $i++){
if ($i == $pageNum) {
$pagelinks .= "<span class=\"pagenumdead\">$i</span>";
} else {
if ($lrange <= $i and $i <= $rrange) {
$pagelinks .= "<a class=\"pagenumlink\" " .
"href=\"" . $self . "&page=" . $i .
"\">" . $i . "</a>";
}
}
}
if ($rrange < $numofpages) {
$pagelinks .= "..";
} else {
$pagelinks .= "  ";
}

if(($numrows - ($rowsPerPage * $pageNum)) > 0){
$pagenext = $pageNum + 1;
$pagelinks .= "<a class=\"pagenextlink\" href=\"" . $self .
"&page=" . $pagenext . "\">Следваща ></a>";
} else {
$pagelinks .= "<span class=\"pagenextdead\">Следваща ></span>";
}
} else {
$pagelinks .= "<span class=\"pageprevdead\">< " .
"Предишна</span>  ";
$pagelinks .= "<span class=\"pagenextdead\"> " .
"Следваща ></span>  ";
}
$pagelinks .= "</div>";
echo $pagelinks ;

?>[/code]

 

[Black]

Намери:
SELECT * FROM $table ORDER BY id
и след него добави:
DESC LIMIT 20
числото 20 е броя на клипчетата.
и трябва да стане:
SELECT * FROM $table ORDER BY id DESC LIMIT 20
Успех!