= $pages) && $pages != 1) {
$last = $offset + $limit;}
else{
$last = $numrows;}
$query = "select image.id, title, category, creator, date, barcode from title, category, creator, image where tid = '$tid' and category.id = '$cat_id' and title.id = tid and cat_id = category.id and cid=creator.id limit $offset, $limit";
$result = mysql_query($query) or die("Error: " . mysql_error());
if (mysql_num_rows($result) == 0)
echo ("No images found.");
?>
The Pusey Collection
Pusey Collection > By Category > ">
Displaying - of images.
=1) {
$prevoffset = $offset - 5;
echo("
PREV ");
}
//moving $pages = intval... to $pages ++; and the } to the top
for ($i = 1; $i <= $pages; $i++) {
$newoffset = $limit*($i-1);
echo ("
$i ");
}
if (!(($offset/$limit) == ($pages -1)) && ($pages !=1)) {
$newoffset=$offset+$limit;
echo("
NEXT");
}
?>
