switch($mode)
{ case "brass" :
$requete = "SELECT * FROM bieres WHERE brasserie LIKE \"%$nom%\" ORDER BY nom";
break;
case "orig" :
$requete = "SELECT * FROM bieres WHERE origine LIKE \"%$nom%\" ORDER BY nom";
break;
case "rech" :
$requete = "SELECT * FROM bieres WHERE nom LIKE \"%$nom%\" ORDER BY nom";
break;
}
// mysql_query ("INSERT INTO stat_req (`mode`, `texte`) VALUES ( '$mode', '$nom')",$db);
$result = mysql_query ($requete,$db) or mysql_die("Aucun enregistrement");
$nbresult = mysql_num_rows($result);
while ($rs=MySQL_Fetch_array($result))
{
echo "\n";
echo "";
echo $lien;
printf(" ",$rs[idb]);
echo " | $rs[nom] | ";
echo "$rs[style] | $rs[brasserie] | $rs[alc] % | ";
}
?>
|