|
// Estraggo tutti gli utenti admin
$data = new Database();
$sql = "SELECT * FROM NORMATIVE,CAT_NORMATIVE WHERE CAT_ID = NORM_ID_CAT ";
$sql .= " GROUP BY CAT_ID ORDER BY CAT_ORDER ";
$ris = $data->Command($sql);
// stampo i record
if ($data->GetNumRows() > 0) {
while($rec = $data->Iterate()) {
$idCat = $rec["CAT_ID"];?>
|
// Estraggo tutti gli utenti admin
$dataFile = new Database();
$sqlFile = "SELECT * FROM NORMATIVE WHERE NORM_ID_CAT = $idCat ";
$sqlFile .= " ORDER BY NORM_TITOLO" . $L;
$risFile = $dataFile->Command($sqlFile);
// stampo i record
if ($dataFile->GetNumRows() > 0) {
$q = 1;
while($recFile = $dataFile->Iterate()) {
$idFile = $recFile["NORM_ID"];?>
|
• =$recFile["NORM_TITOLO" . $L]?> |
|
=$open?> |
|
|
}} $dataFile->Close();?>
|
}} $data->Close();?>
|
// Estraggo tutti gli utenti admin
$data = new Database();
$sql = "SELECT * FROM CAT_DOWN WHERE CAT_ID = 1 ";
$ris = $data->Command($sql);
// stampo i record
if ($data->GetNumRows() > 0) {
while($rec = $data->Iterate()) {
$idCat = $rec["CAT_ID"];?>
|
// Estraggo tutti gli utenti admin
$dataFile = new Database();
$sqlFile = "SELECT * FROM DOWNLOAD WHERE DOWN_ID_CAT = 1 AND DOWN_PERMESSI = 0";
$risFile = $dataFile->Command($sqlFile);
// stampo i record
if ($dataFile->GetNumRows() > 0) {
while($recFile = $dataFile->Iterate()) {
$idFile = $recFile["DOWN_ID"];?>
(
=$recFile["DOWN_SIZE"]?>
kbyte) |
$fileExt = substr($recFile["DOWN_FILE"],strlen($recFile["DOWN_FILE"])-4);?>
}} $dataFile->Close();?>
}} $data->Close();?>
|
|
|
include ('inc-menu_link.php')?> |
|
|