1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61
| <?php
$maxRows_record = 3000;
$pageNum_record = 0;
if (isset($_GET['pageNum_record'])) {
$pageNum_record = $_GET['pageNum_record'];
}
$startRow_record = $pageNum_record * $maxRows_record;
$var_record = "-1";
if (isset($_GET['numseri'])) {
$var_record = (get_magic_quotes_gpc()) ? $_GET['numseri'] : addslashes($_GET['numseri']);
}
mysql_select_db($database_acces, $acces);
$query_record = sprintf("SELECT * FROM table WHERE numseri LIKE %s AND nom LIKE 'A%'
ORDER BY nom ASC", GetSQLValueString($var_record . "%", "text"));
$query_limit_record = sprintf("%s LIMIT %d, %d", $query_record, $startRow_record, $maxRows_record);
$record = mysql_query($query_limit_record, $acces) or die(mysql_error());
$row_record = mysql_fetch_assoc($record);
if (isset($_GET['totalRows_record'])) {
$totalRows_record = $_GET['totalRows_record'];
} else {
$all_record = mysql_query($query_record);
$totalRows_record = mysql_num_rows($all_record);
}
$totalPages_record = ceil($totalRows_record/$maxRows_record)-1;
if(!empty($_GET['lettre'])) {
echo "pas de menu";
}
else {
for($i=65;$i<91;$i++){ echo "<a href=\"#".chr($i)."\">
<strong>".chr($i)."</strong></a>|";
}
}
$prems_lettre='1';
while ($res = mysql_fetch_assoc($record))
{
if(strtolower($res['nom'][0])!= $prems_lettre)
{
$prems_lettre = strtolower($res['nom'][0]);
echo '<a name="'.strtoupper($prems_lettre).'">';
echo "<br />";
echo '<b>- ',strtoupper($prems_lettre),'</b>';
echo "</a>";
echo "<br />";
$prems_lettre = strtolower($res['nom'][0]);
}
echo "<a href=\"#\">".$res['nom']."</a>";
echo "<br />";
}
?> |
Partager