странициране и ид

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 = 1;
   $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` ORDER BY `m_id` DESC LIMIT $start,$pp WHERE `m_cat`='$cat_id'")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>";


}
?>
със него линка е от вида link.php?cat_id=$cat_id или когато е страницирано link.php?cat_id=$cat_id&page=$page
направил съм го като го няма това ?cat_id=$cat_id да се показват всички категории ,но ако го има да се показват песните само от тази категория като могат и да се страницират
но ми дава някакъв проблем
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `m_cat`='1'' at line 1
Увеличете...

sql на music
Код: 
CREATE TABLE `music` (
  `m_id` int(11) NOT NULL auto_increment,
  `m_cat` int(3) NOT NULL,
  `m_name` varchar(255) collate utf8_unicode_ci NOT NULL,
  `m_download` varchar(255) collate utf8_unicode_ci NOT NULL,
  `m_clicks` varchar(255) collate utf8_unicode_ci NOT NULL default '0',
  `m_date` varchar(255) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`m_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

на music_cats
Код: 
CREATE TABLE `music_cats` (
  `mcat_id` int(11) NOT NULL auto_increment,
  `mcat_name` varchar(255) collate utf8_unicode_ci NOT NULL,
  `mcat_text` varchar(250) collate utf8_unicode_ci NOT NULL,
  `mcat_img` varchar(250) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`mcat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=20 ;

въпроса ми е как да има хем ?cat_id=$cat_id хем &page=$page ???
 
$query = mysql_query("SELECT * FROM `music` ORDER BY `m_id` DESC WHERE `m_cat`='$cat_id' LIMIT $start,$pp ")or die(mysql_error());

пробвай така
 
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `m_cat`='1' LIMIT 0,1' at line 1

нещо по кода ще е сигурно ....
 
мм дава ти грешка в sql поне това което ми показваш

пробвай така

$query = mysql_query("SELECT * FROM `music` WHERE `m_cat`='$cat_id' LIMIT $start,$pp ORDER BY `m_id` DESC ")or die(mysql_error());
 
Така се пише заявката

$query = mysql_query("SELECT * FROM `music` WHERE `m_cat`='$cat_id' ORDER BY `m_id` DESC LIMIT $start,$pp ")or die(mysql_error());
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе