$db="larochelle";
mysql_connect("localhost","root");
$sql="SELECT * FROM Rues";
if ($rec!="") $sql.=" WHERE rue LIKE '%" . $rec . "%'";
$sqltmp=$sql;
$conn=mysql_db_query($db,$sql);
$recordcount=mysql_num_rows($conn);
$pagesize=50;
$pagecount=$recordcount/$pagesize;
if($recordcount%$pagesize!=0) $pagecount++;
$firstrecord=($page-1)*$pagesize;
$texte="$recordcount rue(s)".($rec?" contenant \"$rec\"":"");
?>
|
$sql="$sqltmp ORDER BY Rue LIMIT $firstrecord," . ($pagesize+1);
$conn=mysql_db_query($db,$sql);
$row=mysql_fetch_array($conn);
$nblignes=0;
while ($nblignes < $pagesize and $row) {?>
"?> |
|
$row=mysql_fetch_array($conn);
$nblignes++;
}?>
|