include("header.php");
cabecera(4);
include("includes/conexionBD.php");
include_once('includes/encode_name.php');
?>
Catálogo
$sql = 'SELECT IDCATEGORIA, CAT_DESCRIPCION '.
'FROM CATEGORIAS '.
'WHERE CAT_IDCATEGORIAPADRE = 0 AND CAT_ACTIVA = 1 '.
'ORDER BY CAT_ORDEN';
$query = mysqli_query($conx, $sql) or die('Error-'. mysqli_error($conx) );
while ( $fila = mysqli_fetch_array($query) ) {
$num = 0;
$sql2 = 'SELECT IDCATEGORIA, CAT_IDCATEGORIAPADRE, CAT_DESCRIPCION '.
'FROM CATEGORIAS '.
'WHERE CAT_IDCATEGORIAPADRE = '. $fila['IDCATEGORIA'] . ' AND CAT_ACTIVA = 1 ' .
'ORDER BY CAT_ORDEN';
$query2 = mysqli_query($conx, $sql2) or die('Error-'. mysqli_error($conx) );
while ( $cat = mysqli_fetch_array($query2) ) {
$num++;
if ( $num == 1 ) {
echo "\n"; }
} // de while categorias padre = 0
?>
/*
*/?>
include("footer.php");
?>