El problema es en paginar en;
WHERE subcat='$id'
no me muestra nada pero si lo quito eso solo me lleva a otras categorias que no hay nada, y si lo pongo id=$id' no me muestra nada tampoco.
si hay alguien que me pueda ayudar con esto lo estare agradecido toda una eternitad
Código PHP:
include "./config.php";
$entries_per_page=5;
if (!$offset) $offset=0;
if (($ckAdminPass) && ($ckAdminPass==$adminpass) && ($admindelete)){
$sql = "select subcat from $tablescripts where id='$admindelete'";
$result = mysql_query($sql) or die("Failed: $sql");
$numrows = mysql_num_rows($result);
if ($numrows!=0){
$resrow = mysql_fetch_row($result);
$catid = $resrow[0];
$sql = "delete from $tablescripts where id='$admindelete'";
$result = mysql_query($sql) or die("Failed: $sql");
$sql = "select ct from $tablecats where id='$catid'";
$result = mysql_query($sql) or die("Failed: $sql");
$resrow = mysql_fetch_row($result);
$ct = $resrow[0];
$ct--;
$sql = "update $tablecats set ct='$ct' where id='$catid'";
$result = mysql_query($sql) or die("Failed: $sql");
Header("Location: scripts.php");
exit;
}
}
$sql = "select cat from $tablecats where id='$id'";
$result = mysql_query($sql);
$resrow = mysql_fetch_row($result);
$cat = $resrow[0];
$pagetitle = "$sitetitle: PHP Scripts: $cat";
if ($headerfile) include $headerfile;
$sql = "select id,title,homeurl,dlurl,demourl,descr,price,version,hitsout,added from $tablescripts where subcat='$id' order by hitsin desc LIMIT $offset, $entries_per_page";
$result = mysql_query($sql) or die("Failed: $sql");
$numrows = mysql_num_rows($result);
$catid = $id;
//Todo el contenido va aqui
//empezar a paginar
$count_result = mysql_query("SELECT count(*) AS number FROM $tablescripts WHERE subcat='$id") or die ("Query failed!");
while ($count = mysql_fetch_array($count_result)) {
$total_entries = $count["number"];
}
if ($total_entries==0) echo("No posted yet!");
else{
$pages = $total_entries / $entries_per_page;
if ($pages < 1) {
$pages = 1;
}
if ($pages / (int) $pages <> 1) {
$pages = (int) $pages + 1;
}
else {
$pages = $pages;
}
if (($offset > $total_entries) or (!is_numeric($offset)))
$offset = 0;
// current page number
$pagenow = ($offset/$entries_per_page + 1);
echo "<p align=center>Page " . $pagenow . " of " . $pages;
// next/preview links
$next = $offset + $entries_per_page;
$previous = $offset - $entries_per_page;
if ($pages <> 1) {
echo " || ";
if ($previous < 0) {
echo "<a href=cat.php?id=".$id."&offset=" . $next . ">";
echo "<acronym title='Next " . $entries_per_page . " records'>>>></acronym></a>";
}
elseif ($next >= $total_entries) {
echo "<a href=cat.php?id=".$id."&offset=" . $previous . ">";
echo "<acronym title='Previous " . $entries_per_page . " records'><<<</acronym></a>";
}
else {
echo "<a href=cat.php?id=".$id."&offset=" . $previous . ">";
echo "<acronym title='Previous " . $entries_per_page . " records'><<<</acronym></a>";
echo " | ";
echo "<a href=cat.php?id=".$id."&offset=" . $next . ">";
echo "<acronym title='Next " . $entries_per_page . " records'>>>></acronym></a>";
}
echo "</div><br>";
}
// links to all pages
echo "<p class=\"head\" align=\"center\">Page(s):";
$i = 0;
while ($i < $pages) {
$ri = $i + 1;
$showpage = $i * $entries_per_page;
if ($ri == $pagenow)
echo $ri . " ";
else
echo "<a href=cat.php?id=".$id."&offset=" . $showpage . ">" . $ri . "</a> ";
$i++;
}
echo "<br><br><br>";
}
