$sql = "
SELECT societe.nom AS NOMSOC, societe.url AS URLSOC, societe.adresse1 AS AD1SOC,
societe.adresse2 AS AD2SOC, societe.telephone AS TELSOC, societe.email AS EMASOC,
societe.text_pub_fr AS PUFSOC, societe.text_pub_en AS PUESOC, societe.commentaires AS COMSOC,
categorie.nom AS NOMCAT,ville.ville AS NOMVIL, ville.codepostal AS CODVIL,
option.nom AS NOMOPT
FROM societe INNER JOIN societe_categorie ON societe.id = societe_categorie.societe_id
INNER JOIN categorie ON categorie.id = societe_categorie.categorie_id
INNER JOIN option ON option.id=societe_option.option_id
INNER JOIN societe_option ON societe.id=societe_option.societe_id
INNER JOIN ville ON ville.id=societe.ville_id
WHERE societe.vignette<>'no_vignette.png' AND categorie.nom='$categorie1' AND ville.ville LIKE '$multiville' ORDER BY societe.nom";
Partager