PHP and MYSQL : do while that dosn't work

[boggie]

I would like to display Division, then categories under each division and subcategories who's under each catagory. But when I do my do while I didn't receive the right result... example of what I want: \[code\]Division NameCategorie Sub-categorie Sub-categorie Sub-categorieCategorie 2 Sub-categorie 2 Sub-categorie 2 Sub-categorie 2Division Name 2Categorie 3...\[/code\]Sanitaire (that's a division)Produits papiers (that's a categorie)Distributeurs assortis (that's a subcategorie)Distributeurs assortis (that's the same subcategorie...)Distributeurs assortis (and again...)Distributeurs assortis (and again...)(...) i receive the same subcategorie for 10 lines\[quote\] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND \[code\]__Produits_Sous_Cat\[/code\].id_langue = 1 AND \[code\]__Produits_Sous_Cat\[/code\].visible = '1'' at line 1\[/quote\]here's is my code : \[code\]$LANG = 1;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);do { echo '<p>'.$row_divisionlist['titre'].'</p>'; mysql_select_db($database_dl, $dl); $query_categorielist = "SELECT * FROM `__Produits_Cat` WHERE `__Produits_Cat`.id_Division = ".$row_divisionlist['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); do { echo '<p>'.$row_categorielist['titre'].'</p>'; mysql_select_db($database_dl, $dl); $query_scategorie = "SELECT * FROM `__Produits_Sous_Cat` WHERE `__Produits_Sous_Cat`.id_Produit_Cat = ".$row_categorielist['id']." 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); do { echo '<p>'.$row_scategorie['titre'].'</p>'; mysql_select_db($database_dl, $dl); $query_sscategorie = "SELECT * FROM `__Produits_Sous_sousCat` WHERE `__Produits_Sous_sousCat`.id_Produit_Sous_Cat = ".$row_scategorie['id']." 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); do { echo '<p>'.$row_sscategorie['titre'].'</p>'; } while ($row_divisionlist = mysql_fetch_assoc($divisionlist)); } while ($row_categorielist = mysql_fetch_assoc($categorielist)); } while ($row_scategorie = mysql_fetch_assoc($scategorie));} while ($row_sscategorie = mysql_fetch_assoc($sscategorie));\[/code\]Thank you very much for your help.