"") {
$Req_Donnees="SELECT Donnees.*, Classes.Classe, Categories.Categorie, Familles.Famille
FROM ((Donnees LEFT JOIN Classes ON Donnees.Cla = Classes.Code)
LEFT JOIN Categories ON (Donnees.Cla = Categories.Classe) AND (Donnees.Cat = Categories.Code))
LEFT JOIN Familles ON (Donnees.Fam = Familles.Code) AND (Donnees.Cat = Familles.Cat)";
$Req_Donnees_A="ORDER BY Categorie, Famille, Nom";
$db="larochelle";
mysql_connect("localhost","root");
?>
Recherche Globale
$sql="$Req_Donnees WHERE Nom LIKE '%$rec%' OR Classes.Classe LIKE '%$rec%' OR Categories.Categorie LIKE '%$rec%' OR Familles.Famille LIKE '%$rec%' ";
$conn=mysql_db_query($db,$sql);
$recordcount=mysql_num_rows($conn);
$pagesize=10;
$pagecount=$recordcount/$pagesize;
if($recordcount%$pagesize!=0) $pagecount++;
$firstrecord=($page-1)*$pagesize;
$sql="$Req_Donnees WHERE Nom LIKE '%$rec%' OR Classes.Classe LIKE '%$rec%' OR Categories.Categorie LIKE '%$rec%' OR Familles.Famille LIKE '%$rec%' $Req_Donnees_A LIMIT $firstrecord,".($pagesize+1);
$conn=mysql_db_query($db,$sql);
$row=mysql_fetch_array($conn);
$curcat="";
$curfam="";
$nblignes=0;
$texte="$recordcount référence(s)".($rec?" contenant \"$rec\"":"");?>
while($nblignes<10 and $row) {?>
$row[Cat]) {
$curcat=$row[Cat];?>