Expertrec

[insert_php]
//page EXPERTREC
global $chemin;
global $wpdb;
global $table_experts;

if (empty($_GET[‘myvar’]))
{$myvar = ‘AER’;}
else
{$myvar = $_GET[‘myvar’];}

//echo ‘myvar=’ . $myvar . ‘
‘;

$sql = ‘SELECT ‘ . $table_experts . ‘.NE, ‘ . $table_experts . ‘.Nom, ‘ . $table_experts . ‘.Prenom ‘;
$sql = $sql . ‘FROM ‘ . $table_experts . ‘ ‘;
$sql = $sql . ‘WHERE (((‘ . $table_experts . ‘.Nom) LIKE « %’. $myvar .’% »))’;
$cpfexperts = $wpdb->get_results($sql);

$numcpfexperts = count($cpfexperts);
//echo ‘nombre cpf expert ‘ . $numcpfexperts . ‘
‘;
// on affiche le code CPF
echo ‘

Search results for : ‘ . $myvar . ‘

‘;

if ($numcpfexperts > 0){
echo ‘