1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
|
$sql="SELECT type_partenaire,continent,country,state,company,contact,address1,address2,address3,zipcode,town,phone1,phone2,fax,email,webSite FROM tbl_resellers where continent like '".$continent_selected."'and type_partenaire like '".$type_selected."' and country like '".$country_selected."' order by 2,3,4,5 ";
echo $sql;
# affichage des données
echo '<div class="Resellers">';
if ($resultats=mysqli_query($connexion,$sql)){
while ($ligne=mysqli_fetch_assoc($resultats)) {
echo '<tr>';
switch ($ligne['type_partenaire']) {
case 'O':
echo '<td>OEM</td>';
break;
case 'R':
echo '<td>RESELLER</td>';
break;
case 'A':
echo '<td>AGENT</td>';
break;
};
echo '<td>'.$ligne['continent'].'</td>';
echo '<td>'.$ligne['country'].'</td>';
echo '<td>'.$ligne['state'].'</td>';
echo '<td>'.$ligne['company'].'</td>';
echo '<tr><td><th scope="Contact">Contact : </th></td></td><td>'.$ligne['contact'].'</td></tr>';
echo '<tr><td><th scope="Address1">Address : </th></td></td><td>'.$ligne['address1'].'</td></tr>';
if ($ligne['address2'] <> '') {
echo '<tr><td><td> </td></td><td>'.$ligne['address2'].'</td></tr>';
}
if ($ligne['address3'] <> '') {
echo '<tr><td><td> </td></td><td>'.$ligne['address3'].'</td></tr>';
}
echo '<tr><td><th scope="Zip Code">Zip Code : </th></td><td>'.$ligne['zipcode'].'</td><<th scope="City">City : </td><td>'.$ligne['town'].'</td></tr>';
echo '</tr>';
}
}
else {
echo 'No partner!';
} |
Partager