Hi, i would like to add a pagination on arylia galleries, i have a php file that query all galleries from the sql, but now its more than 650 galleries and i would like to limit 60 galleries per page, can you guys help me out please?
thank you,
Sam
the code im using is:
mysql_connect($db_host, $db_user, $db_pass);
mysql_select_db($db_db);
$galsResult = mysql_query("SELECT galleryUrl, galleryName FROM $gal_table ORDER BY createDate DESC");
while($thisGallery = mysql_fetch_assoc($galsResult)) {
?> <a href="<?= $thisGallery["galleryUrl"] ?>" target=_blank"><img src="<?= substr($thisGallery["galleryUrl], 0, strrpos($thisGallery["galleryUrl"], "/")) ?>/thumbs/preview.jpg"></a>
<?
}
?>