require("../top.inc.php3"); require("../menu_guide.inc.php3"); ?>
Recherche des Catégories par NOM
"") { $db="larochelle"; mysql_connect("localhost","root"); ?>
Liste des Catégories
$sql="SELECT Classes.Code, Classes.Classe, Categories.Code, Categories.Categorie, Familles.Code, Familles.Famille FROM (Categories LEFT JOIN Familles ON Categories.Code = Familles.Cat) LEFT JOIN Classes ON Categories.Classe = Classes.Code"; if($rec!="") $sql.=" WHERE Categorie LIKE \"%$rec%\" OR Famille LIKE \"%$rec%\""; $sqltmp=$sql; $conn=mysql_db_query($db,$sql); $recordcount=mysql_num_rows($conn); $pagesize=20; $pagecount=$recordcount/$pagesize; if($recordcount%$pagesize!=0) $pagecount++; $firstrecord=($page-1)*$pagesize; $sql=$sqltmp . " ORDER BY Categories.Categorie, Familles.Famille LIMIT $firstrecord,".($pagesize+1); $conn=mysql_db_query($db,$sql); $row=mysql_fetch_array($conn); $texte="$recordcount référence(s)".($rec?" contenant \"$rec\"":"");?>
$curcat=""; $nblignes=0; while($nblignes < $pagesize and $row) {?> if($curcat<>$row[Categorie]) { $curcat=$row[Categorie];?>
">
}?>
">
$row=mysql_fetch_array($conn); $nblignes++; }?>
$firstpage=floor(($page-1)/10)*10+1; $lastpage=$firstpage+9; if($firstpage>1) {?>
">
} for($i=$firstpage;$i<=$lastpage;$i++) { if($i==$page) {?>
} elseif($i>$pagecount) {?>
} else {?>
">
} } if($i<=$pagecount) {?>
">
}?>
} else {?>
}?>