"" and $tri<>"") {
if($cat=="CONST") echo '
';
if($cat=="GARAG") echo '
';
?>
|
"") {
if($rec=="") {
$sql=$Req_Donnees . " WHERE Cat='$cat' AND Fam='$fam'";
$conn=mysql_db_query($db,$sql);
$recordcount=mysql_num_rows($conn);
$pagesize=10;
$pagecount=$recordcount/$pagesize;
if($recordcount%$pagesize!=0) $pagecount++;
$var="Req_Donnees_" . $tri;
$sql=$Req_Donnees . " WHERE Cat='$cat' AND Fam='$fam' " . ${$var} . " LIMIT " . ($page-1)*$pagesize . "," . ($pagesize+1);
} else {
$sql=$Req_Donnees . " WHERE Cat='$cat' AND Fam='$fam' AND Nom LIKE '%" . $rec . "%'";
$conn=mysql_db_query($db,$sql);
$recordcount=mysql_num_rows($conn);
$pagesize=10;
$pagecount=$recordcount/$pagesize;
if($recordcount%$pagesize!=0) $pagecount++;
$var="Req_Donnees_" . $tri;
$sql=$Req_Donnees . " WHERE Cat='$cat' AND Fam='$fam' AND Nom LIKE '%" . $rec . "%' " . ${$var} . " LIMIT " . ($page-1)*$pagesize . "," . ($pagesize+1);
}
$conn=mysql_db_query($db,$sql);
} else {
if($rec=="") {
$sql=$Req_Donnees . " WHERE Cat='$cat'";
$conn=mysql_db_query($db,$sql);
$recordcount=mysql_num_rows($conn);
$pagesize=10;
$pagecount=$recordcount/$pagesize;
if($recordcount%$pagesize!=0) $pagecount++;
$var="Req_Donnees_" . $tri;
$sql=$Req_Donnees . " WHERE Cat='$cat' " . ${$var} . " LIMIT " . ($page-1)*$pagesize . "," . ($pagesize+1);
}
else {
$sql=$Req_Donnees . " WHERE Cat='$cat' AND Nom LIKE '%" . $rec . "%'";
$conn=mysql_db_query($db,$sql);
$recordcount=mysql_num_rows($conn);
$pagesize=10;
$pagecount=$recordcount/$pagesize;
if($recordcount%$pagesize!=0) $pagecount++;
$var="Req_Donnees_" . $tri;
$sql=$Req_Donnees . " WHERE Cat='$cat' AND Nom LIKE '%" . $rec . "%' " . ${$var} . " LIMIT " . ($page-1)*$pagesize . "," . ($pagesize+1);
}
$conn=mysql_db_query($db,$sql);
}
$row=mysql_fetch_array($conn);
$texte="$recordcount référence(s)".($rec?" contenant \"$rec\"":"")." dans $text_classe - $text_cat".($fam?" ($text_fam)":"");?>
|
 |
| ">
|
| |
0) {
for($i=1;$i<=$row[Etoiles];$i++) {
if($row[Infos]) {?>
Tél:
()
Fax:
Email:
 |
| |
|
 |
1) {?>
"> |
 |
 |
|
$pagecount) {?>
|
"> |
|
"> |
|
 |
Veuillez choisir une catégorie...
|
Veuillez choisir une rubrique...
|
.gif" width=14 height=11 border=0>
