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 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73
| $requete = "
SELECT raison_sociale, dirigeant, adresse, cp, region, ville, tel, telecopie, email, email2, code_naf, libelle_naf, rubrique_professionnelle
FROM `liste`
WHERE
";
if ($raison != '')
{
$requete .= " raison_sociale LIKE '%$raison%' ";
}
if ($dirige != '')
{
$requete .= "OR dirigeant LIKE '%$dirige%' ";
}
if ($adresse != '')
{
$requete .= "OR adresse LIKE '%$adresse%' ";
}
if ($cp != '')
{
$requete .= "OR cp LIKE '%$cp%' ";
}
if ($region != '')
{
$requete .= "OR region LIKE '%$region%' ";
}
if ($ville != '')
{
$requete .= "OR ville LIKE '%$ville%' ";
}
if ($telephone != '')
{
$requete .= "OR tel LIKE '%$telephone%' ";
}
if ($telecopie != '')
{
$requete .= "OR telecopie LIKE '%$telecopie%' ";
}
if ($email != '')
{
$requete .= "OR email LIKE '%$email%' ";
}
if ($email2 != '')
{
$requete .= "OR email2 LIKE '%$email2%' ";
}
if ($code_naf != '')
{
$requete .= "OR code_naf LIKE '%$code_naf%' ";
}
if ($libelle_naf != '')
{
$requete .= "OR libelle_naf LIKE '%$libelle_naf%' ";
}
if ($rubrique_professionnelle != '')
{
$requete .= "OR rubrique_professionnelle LIKE '%$rubrique_professionnelle%' ";
} |
Partager