Section

[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 ‘

‘ . $sections[0]->NS . ‘ – ‘ . $libelle . ‘

‘;

$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 ‘

‘;
foreach ($niveaux as $niveau){

//echo $niveau->libelle . ‘
‘;
//echo strlen(trim(($niveau->CPF)) . ‘
‘;
if (strlen(trim($niveau->CPF))<5) { echo '

‘;
echo ‘

‘ . $niveau->CPF . ‘ RETOUR

‘;
}

[/insert_php]