[insert_php]
//page SECTION
global $chemin;
global $wpdb;
global $table_sections;
global $table_rubriques;
global $table_niveaux;
echo ‘
RETOUR
‘;
if(empty($_GET[‘myvar’]))
{$myvar = ‘A’;}
else
{$myvar = $_GET[‘myvar’];}
//echo ‘myvar=’ . $myvar . ‘
‘;
//echo ‘table section=’ . $table_sections . ‘
‘;
//echo ‘RETOUR
‘;
$sections = $wpdb->get_results(« SELECT * FROM $table_sections WHERE NS = ‘ » . $myvar . « ‘ORDER BY section »);
$libelle = substr($sections[0]->part, 11, strlen($sections[0]->part)-11);
echo ‘
‘;
$sql = ‘SELECT * FROM ‘ . $table_rubriques . ‘ WHERE (((‘ . $table_rubriques . ‘.NS)= »‘ . $sections[0]->NS . ‘ »))’;
//echo $sql . ‘
‘;
$rubriques = $wpdb->get_results($sql);
$numrubriques = count($rubriques);
//echo $numrubriques .’
‘;
if ($numrubriques > 0){
foreach ($rubriques as $rubrique){
//echo $rubrique->NR .’
‘;
$sql = ‘SELECT * FROM ‘ . $table_niveaux . ‘ WHERE ((( ‘ . $table_niveaux . ‘.CPF) Like « ‘ . $rubrique->NR . ‘% »))’;
$niveaux = $wpdb->get_results($sql);
$numniveaux = count($niveaux);
//echo $numniveaux . ‘
‘;
if ($numniveaux>0){
echo ‘
‘ . $niveau->CPF . ‘ | CPF . ‘&lang=en>’ . $niveau->description . ‘ |
‘;
}
}
echo ‘
RETOUR
‘;
}
[/insert_php]