LISTA PRODOTTI
include ("Includes/config.php");
$sql->query("
SELECT
cat.nome,
cat.id as idcategoria,
subcat.nome as subcat,
subcat.id,
subcat.idcat
FROM
cat
LEFT OUTER JOIN subcat ON (cat.id=subcat.idcat)
ORDER BY
cat.nome,
subcat.nome
");
$old = "";
echo("");
while($row = $sql->fetch())
{
if($old != $row['nome'])
{
$old = $row['nome'];
print(<<
{$row['nome']}
EOF
);
}
if($row['subcat'] != "")
{
print(<<{$row['subcat']}
EOF
);
}
}
?> |
|
|
|
|
ATC ASSISTENZA TECNICA CARRELLI s.n.c. di Lazzarotto S.& C.Via Borlinetto, 4 - 35100 PADOVA - info@atcsnc.it |
|
|
SEDE OPERATIVA:
Via Piccà Grolli, 2 Bis (ang. Via Industria)- 35030 RUBANO (PD) - Tel. 049.8987188 - Fax 049.8987202 |
|
|