[insert_php]
$occup = $_POST[occupation];
$button = $_GET[button];

global $pict_file;
global $modtrad_page;
global $comid;
global $connect;
$connect = mysqli_connect( ’emanetorg.mysql.db’, ’emanetorg’, ‘Xt6PsTNdS2′, ’emanetorg’ ) or die ( “Connexion au serveur sql impossible” );
if ($button == 1){
$modtrad_page = ‘

‘;

$modtrad_page .= “

List of persons corresponding to your researc: “; $modtrad_page .= ‘Please select\n’; $req1 = mysqli_query($connect,”SELECT userid,last_name,first_name,occupation FROM SaveContactForm7_8 WHERE occupation = ‘$occup’ ORDER BY last_name ASC”) or die(‘Erreur SQL871 !’); while ($res1 = mysqli_fetch_row($req1)) { $modtrad_page .= ““; $modtrad_page .= “

“;
}

if ($button == 2){
$modtrad_page = ‘

‘;

$modtrad_page .= “

List of persons corresponding to your researc: “; $modtrad_page .= ‘Please select\n’; $req1 = mysqli_query($connect,”SELECT userid,last_name,first_name,specialisation FROM SaveContactForm7_8 WHERE specialisation = ‘$occup’ ORDER BY last_name ASC”) or die(‘Erreur SQL871 !’); while ($res1 = mysqli_fetch_row($req1)) { $modtrad_page .= ““; $modtrad_page .= “

“;
}

if ($button == 3){
$modtrad_page = ‘

‘;

$modtrad_page .= “

List of persons corresponding to your researc: “; $modtrad_page .= ‘Please select\n’; $req1 = mysqli_query($connect,”SELECT userid,last_name,first_name,specificcompetence FROM SaveContactForm7_8 WHERE specificcompetence = ‘$occup’ ORDER BY last_name ASC”) or die(‘Erreur SQL871 !’); while ($res1 = mysqli_fetch_row($req1)) { $modtrad_page .= ““; $modtrad_page .= “

“;
}

if ($button == 4){
$modtrad_page = ‘

‘;

$modtrad_page .= “

List of persons corresponding to your research : “; $modtrad_page .= ‘Please select\n’; $req1 = mysqli_query($connect,”SELECT userid,last_name,first_name,specificcompetence FROM SaveContactForm7_8 WHERE language = ‘$occup’ OR language2 = ‘$occup’ OR language3 = ‘$occup’ ORDER BY last_name ASC”) or die(‘Erreur SQL871 !’); while ($res1 = mysqli_fetch_row($req1)) { $modtrad_page .= ““; $modtrad_page .= “

“;
}
echo $modtrad_page;
[/insert_php]