проблем с странициране

I

IzKuFeLiQqQqQ

Registered
имам този код
Код: 
<?php
$cat_id = (int)$_GET['cat_id'];
include ('./files/config.php');
if(!$cat_id){
$query = mysql_query("SELECT * FROM `music_cats` ORDER BY `mcat_id` ASC")or die(mysql_error());
while($row = mysql_fetch_array($query)){
$id = $row['mcat_id'];
$name = $row['mcat_name'];
$text = $row['mcat_text'];
$img = $row['mcat_img'];
echo '<img src="'.$img.'"/> <a href="music.php?cat_id='.$id.'">'.$name.'</a>  '.$text.'<br>'; 
}
}
if($cat_id){
               $page = (int)$_GET['page'];
   if($page == 0 || $page == NULL || $page < 0  AND $cat_id)
   {
   $page = 1;
   }
   $pp = 5;
   $start = ($page*$pp) - $pp;
   include ('./files/config.php');
   $query = mysql_query("SELECT * FROM `music` "); 
   $broi = mysql_num_rows($query);
   $total = ceil($broi/$pp);

 
$query = mysql_query("SELECT * FROM `music` WHERE `m_cat`='$cat_id' ORDER BY `m_id` DESC LIMIT $start,$pp ")or die(mysql_error());
while($row=mysql_fetch_assoc($query)) {
$m_id = $row['m_id'];
$m_name = $row['m_name'];
$m_download = $row['m_download'];
echo "<a href='song.php?id=$m_id'>$m_name</a><br><br>";
}
   echo "<div id = 'STR' style = 'width:572px; color:#fff;'>";   // tuka mojesh da si promenish stilovete (css) drugoto ne go barash


if (!$page or ($page > $total)) {
$page="1";
}

if ($total < 10) {
for($i=1 ; $i<=$total ; $i++) {
if ( ($page)==$i ) {
echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px; '>$i</b> ";
}
else {
echo "<a style='  background: url(images/STR.jpg) no-repeat; color:#fff; padding-left:8px; padding-right:8px; padding-bottom:1px; ' href=\"?cat_id=".$cat_id."&page=".$i."\"><b>".$i."</b></a> ";
}
}
}
else {
for($i=1 ; $i<=3 ; $i++) {
if ( ($page)==$i ) {
echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> ";
}
else {
echo "<a style='  background: url(images/STR.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?cat_id=".$cat_id."&page=".$i."\">".$i."</a> ";
}
}

if ($page <= 3) {
if ($page == 3) echo "<a style='  background: url(images/STR.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?cat_id=".$cat_id."&page=4\">4</a> ";
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a style='  background: url(images/STR.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?cat_id=".$cat_id."&page=".$i."\">".$i."</a> ";
}
if ($page == 5) $parva.= "<a style='  background: url(images/STR.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?cat_id=".$cat_id."&page=4\">4</a> ";

if ( ($page == 4) or ($page == 5) ) {
for ($i=$page; $i<=$page+1; $i++) {
if ($page == $i) echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> ";
else echo "<a style=' background: url(images/STR.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?cat_id=".$cat_id."&page=".$i."\">".$i."</a> ";
}
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a style=' background: url(images/STR.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?cat_id=".$cat_id."&page=".$i."\">".$i."</a> ";
}

if ( ($page > 5) and ($page < ($total - 4)) ) {
echo "... ";
for ($i=$page-1; $i<=$page+1; $i++) {
if ($page == $i) echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> ";
else echo "<a style=' background: url(images/STR.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px; ' href=\"?cat_id=".$cat_id."&page=".$i."\">".$i."</a> ";
}
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a style=' background: url(images/STR.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px; ' href=\"?cat_id=".$cat_id."&page=".$i."\">".$i."</a> ";
}

if ( $page > ($total - 5) ) {
echo "... ";
for ($i=$total-5; $i<=$total; $i++) {
if ($page == $i) echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> ";
else echo "<a style='  background: url(images/STR.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px; ' href=\"?cat_id=".$cat_id."&page=".$i."\">".$i."</a> ";
}
}
}


   echo"</div>";


}
?>
но има проблем http://trying.herobo.com/system%20no%20jq/music.php колкото страници има в едната категори толкова има и в другите
как да го направя страницирането да е за определен m_cat ...
 
Опитай така:
Код: 
<?php 
$cat_id = (int)$_GET['cat_id']; 
include ('./files/config.php'); 
if(!$cat_id){ 
$query = mysql_query("SELECT * FROM `music_cats` ORDER BY `mcat_id` ASC")or die(mysql_error()); 
while($row = mysql_fetch_array($query)){ 
$id = $row['mcat_id']; 
$name = $row['mcat_name']; 
$text = $row['mcat_text']; 
$img = $row['mcat_img']; 
echo '<img src="'.$img.'"/> <a href="music.php?cat_id='.$id.'">'.$name.'</a>  '.$text.'<br>'; 
} 
} 
if($cat_id){ 
               $page = (int)$_GET['page']; 
   if($page == 0 || $page == NULL || $page < 0  AND $cat_id) 
   { 
   $page = 1; 
   } 
   $pp = 5; 
   $start = ($page*$pp) - $pp; 
   include ('./files/config.php'); 
   $query = mysql_query("SELECT * FROM `music` "); 
   $broi = mysql_num_rows($query); 
   $total = ceil($broi/$pp); 

  
$query = mysql_query("SELECT * FROM `music` WHERE `m_cat`= $cat_id ORDER BY `m_id` DESC LIMIT $start,$pp ")or die(mysql_error()); 
while($row=mysql_fetch_assoc($query)) { 
$m_id = $row['m_id']; 
$m_name = $row['m_name']; 
$m_download = $row['m_download']; 
echo "<a href='song.php?id=$m_id'>$m_name</a><br><br>"; 
} 
   echo "<div id = 'STR' style = 'width:572px; color:#fff;'>";   // tuka mojesh da si promenish stilovete (css) drugoto ne go barash 


if (!$page or ($page > $total)) { 
$page="1"; 
} 

if ($total < 10) { 
for($i=1 ; $i<=$total ; $i++) { 
if ( ($page)==$i ) { 
echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px; '>$i</b> "; 
} 
else { 
echo "<a style='  background: url(images/STR.jpg) no-repeat; color:#fff; padding-left:8px; padding-right:8px; padding-bottom:1px; ' href=\"?cat_id=".$cat_id."&page=".$i."\"><b>".$i."</b></a> "; 
} 
} 
} 
else { 
for($i=1 ; $i<=3 ; $i++) { 
if ( ($page)==$i ) { 
echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> "; 
} 
else { 
echo "<a style='  background: url(images/STR.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?cat_id=".$cat_id."&page=".$i."\">".$i."</a> "; 
} 
} 

if ($page <= 3) { 
if ($page == 3) echo "<a style='  background: url(images/STR.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?cat_id=".$cat_id."&page=4\">4</a> "; 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a style='  background: url(images/STR.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?cat_id=".$cat_id."&page=".$i."\">".$i."</a> "; 
} 
if ($page == 5) $parva.= "<a style='  background: url(images/STR.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?cat_id=".$cat_id."&page=4\">4</a> "; 

if ( ($page == 4) or ($page == 5) ) { 
for ($i=$page; $i<=$page+1; $i++) { 
if ($page == $i) echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> "; 
else echo "<a style=' background: url(images/STR.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?cat_id=".$cat_id."&page=".$i."\">".$i."</a> "; 
} 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a style=' background: url(images/STR.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;' href=\"?cat_id=".$cat_id."&page=".$i."\">".$i."</a> "; 
} 

if ( ($page > 5) and ($page < ($total - 4)) ) { 
echo "... "; 
for ($i=$page-1; $i<=$page+1; $i++) { 
if ($page == $i) echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> "; 
else echo "<a style=' background: url(images/STR.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px; ' href=\"?cat_id=".$cat_id."&page=".$i."\">".$i."</a> "; 
} 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a style=' background: url(images/STR.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px; ' href=\"?cat_id=".$cat_id."&page=".$i."\">".$i."</a> "; 
} 

if ( $page > ($total - 5) ) { 
echo "... "; 
for ($i=$total-5; $i<=$total; $i++) { 
if ($page == $i) echo "<b style='background: url(images/STR_ACTIVE.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px;'>$i</b> "; 
else echo "<a style='  background: url(images/STR.jpg) no-repeat; padding-left:8px; padding-right:8px; padding-bottom:1px; ' href=\"?cat_id=".$cat_id."&page=".$i."\">".$i."</a> "; 
} 
} 
} 


   echo"</div>"; 


} 
?>
 
успях :twisted: промених горната заявка ...

Код: 
   $start = ($page*$pp) - $pp;
   include ('./files/config.php');
   $query = mysql_query("SELECT * FROM `music` WHERE `m_cat`= $cat_id ");
   $broi = mysql_num_rows($query);
   $total = ceil($broi/$pp);
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе