$v) $$k=$v;
foreach($_GET as $k=>$v) $$k=$v;
setlocale(LC_ALL, "es_ES"); // fecha en español
include 'coneccion/enchufe.php';
$catsinicial=mysql_query("SELECT * FROM categorias ORDER BY orden ASC LIMIT 0,1");
$catinicial=mysql_fetch_assoc($catsinicial);
if (!isset($c)) {
$c = $catinicial['id'];
}
if (isset($_GET['page'])) {
$page = $_GET['page'];
} else {
$page = 1;
}
$query = "SELECT count(*) FROM productos WHERE categoria = '$c' AND activo='1'";
$result = mysql_query($query) or trigger_error("SQL", E_USER_ERROR);
$query_data = mysql_fetch_row($result);
$numrows = $query_data[0];
$rows_per_page = 12;
$lastpage = ceil($numrows/$rows_per_page);
$page = (int)$page;
if ($page > $lastpage) {
$page = $lastpage;
} // if
if ($page < 1) {
$page = 1;
}
if ($page != $lastpage) {
$nextpage = $page+1;
}
if ($page != 1) {
$prevpage = $page-1;
}
$limit = 'LIMIT ' .($page - 1) * $rows_per_page .',' .$rows_per_page;
$lista=mysql_query("SELECT * FROM productos WHERE categoria = '$c' AND activo = '1' ORDER BY categoria ASC $limit");
$categorias=mysql_query("SELECT * FROM categorias WHERE activo = '1' ORDER BY orden ASC");
?>
Productos | Media Tensión
