$lang=""; if(isset($_GET["Codelang"])){ switch($_GET["Codelang"]){ case "fr": $lang=""; break; case "en": $lang="en"; break; } } $lang2="fr"; if($lang=="en") $lang2="en"; include("common/configapp.php"); $tabcat=array(); $j=0; $reqcat=mysql_query("SELECT Titre_cat".$lang." Titre_cat, categorie.ID_cat, count( * ) AS num,ID_categorie_article FROM categorie left join categorie_article on categorie_article.ID_cat = categorie.ID_cat GROUP BY categorie.ID_cat ORDER BY TRIM(Titre_cat)")or die(mysql_error()); while($rescat=mysql_fetch_array($reqcat)){ $tabcat[$j][1]=$rescat["ID_cat"]; $tabcat[$j][0]=trim($rescat["Titre_cat"]); $tabcat[$j][2]=$rescat["num"]; $tabcat[$j][3]=$rescat["ID_categorie_article"]; $j++; } ?>