Liste complète des switch($sort) { case "nom" : $requete = "SELECT * FROM bieres ORDER BY nom"; break; case "part" : $requete = "SELECT * FROM bieres ORDER BY particularite"; break; case "brass" : $requete = "SELECT * FROM bieres ORDER BY brasserie"; break; case "style" : $requete = "SELECT * FROM bieres ORDER BY style"; break; case "vol" : $requete = "SELECT * FROM bieres ORDER BY vol"; break; case "alc" : $requete = "SELECT * FROM bieres ORDER BY alc"; break; default : $requete = "SELECT * FROM bieres ORDER BY vol"; } $result = mysql_query ($requete,$db) or mysql_die("Aucun enregistrement"); $nbresult = mysql_num_rows($result); echo "$nbresult bières"; ?>
| Nom
|
Particularité
|
Brasserie
|
Style
|
Alc.
|
Vol.
|
||||||
| |||||||||||