1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
| function division ($LANG) {
global $database_dl, $dl, $DIVISION_ID, $ID_CAT, $ID_SCAT;
mysql_select_db($database_dl, $dl);
$query_divisionlist = "SELECT * FROM `__Division` WHERE `__Division`.id_langue = ".$LANG." AND `__Division`.visible = 1";
$divisionlist = mysql_query($query_divisionlist, $dl) or die(mysql_error());
$row_divisionlist = mysql_fetch_assoc($divisionlist);
$totalRows_divisionlist = mysql_num_rows($divisionlist);
}
function cat ($DIVISION_ID, $LANG) {
global $database_dl, $dl, $DIVISION_ID, $ID_CAT, $ID_SCAT;
mysql_select_db($database_dl, $dl);
$query_categorielist = "SELECT * FROM `__Produits_Cat` WHERE `__Produits_Cat`.id_Division = ".$DIVISION_ID." and `__Produits_Cat`.id_langue = ".$LANG." and `__Produits_Cat`.visible = 1";
$categorielist = mysql_query($query_categorielist, $dl) or die(mysql_error());
$row_categorielist = mysql_fetch_assoc($categorielist);
$totalRows_categorielist = mysql_num_rows($categorielist);
}
function scat ($ID_CAT,$LANG) {
global $database_dl, $dl, $DIVISION_ID, $ID_CAT, $ID_SCAT;
mysql_select_db($database_dl, $dl);
$query_scategorie = "SELECT * FROM `__Produits_Sous_Cat` WHERE `__Produits_Sous_Cat`.id_Produit_Cat = ".$ID_CAT." AND `__Produits_Sous_Cat`.id_langue = ".$LANG." AND `__Produits_Sous_Cat`.visible = 1";
$scategorie = mysql_query($query_scategorie, $dl) or die(mysql_error());
$row_scategorie = mysql_fetch_assoc($scategorie);
$totalRows_scategorie = mysql_num_rows($scategorie);
}
function sscat ($ID_SCAT, $LANG) {
global $database_dl, $dl, $DIVISION_ID, $ID_CAT, $ID_SCAT;
mysql_select_db($database_dl, $dl);
$query_sscategorie = "SELECT * FROM `__Produits_Sous_sousCat` WHERE `__Produits_Sous_sousCat`.id_Produit_Sous_Cat = ".$ID_SCAT." AND `__Produits_Sous_sousCat`.id_langue = ".$LANG." AND `__Produits_Sous_sousCat`.visible = 1";
$sscategorie = mysql_query($query_sscategorie, $dl) or die(mysql_error());
$row_sscategorie = mysql_fetch_assoc($sscategorie);
$totalRows_sscategorie = mysql_num_rows($sscategorie);
}
?>
<?php
$LANG = 1;
division(1);
do { ?>
<p><?php echo $row_divisionlist['titre']; ?></p>
<? cat($row_divisionlist['id'],$LANG); ?>
<?php do { ?>
<p><?php echo $row_categorielist['titre']; ?></p>
<? scat($row_categorielist['id'],$LANG); ?>
<?php do { ?>
<p><?php echo $row_scategorie['titre']; ?></p>
<? sscat($row_scategorie['id'],$LANG); ?>
<?php do { ?>
<p><?php echo $row_sscategorie['titre']; ?></p>
<?php } while ($row_sscategorie = mysql_fetch_assoc($sscategorie)); mysql_free_result($sscategorie);?>
<?php } while ($row_scategorie = mysql_fetch_assoc($scategorie)); mysql_free_result($scategorie); ?>
<?php } while ($row_categorielist = mysql_fetch_assoc($categorielist)); mysql_free_result($categorielist);?>
<?php } while ($row_divisionlist = mysql_fetch_assoc($divisionlist)); ?>
</body>
</html>
<?php
mysql_free_result($divisionlist); |
Partager