');
$qry = "SELECT count(*) FROM photos WHERE dir='$thispage'";
$result = mysql_query($qry);
$row = mysql_fetch_row($result);
$perpage = 12;
$numpages = ceil($row[0] / $perpage);
$page = $_REQUEST['page'];
if (strval(intval($page)) != $page || $page < 1) $page = 1;
if ($page > $numpages) $page = $numpages;
$qry = "SELECT min(phid) FROM photos WHERE dir='$thispage'";
$result = mysql_query($qry);
$row = mysql_fetch_row($result);
$min = $row[0] + ($page-1)*$perpage;
$qry = "SELECT photos.phid, filename, descr, count(comments.phid) ".
"FROM photos LEFT JOIN comments ON photos.phid=comments.phid ".
"WHERE dir='$thispage' ".
"AND photos.phid BETWEEN $min AND $min+$perpage-1 ".
"GROUP BY photos.phid";
$result = mysql_query($qry);
while ($row = mysql_fetch_row($result)) {
printf('
%s
', $row[1], $row[2]);
printf('Comments (%s)', $row[0], $row[3]);
printf("
\n");
}
print('
');
for ($i = 1; $i <= $numpages; $i++) {
if ($i == $page)
print("$i ");
else
print("$i ");
}
?>
Si vous voyez un faux pas, envoyez-moi la correction � (SVP!):
[tomo arobase infinitedata point net]