PHP/MySQL General Question

[skyphix]

So, Im trying to make a thumbnailed image gallery for my site... learning PHP strictly from tuturials...

Right now, what Im concerned with doing is figuring out how to tell the page to generate X amount of thumbnails per page, which I figured I would do using the ID part of my table.

something like

if ($id > ($maxrow*$maxcolumn)) {
echo "<a href=\"page\">";
}

What Im not sure how to do is find the highest ID number.

Any suggestions... or even suggestions on a better way to accomplish my task?

Thanks for the help...

[[deleted]]

SQL has a LIMIT clause with which you can define how many of the selected rows you actually want to receive.

The syntax is:

SELECT *
FROM table
WHERE foo=bar
LIMIT offset, length;

So LIMIT 0,10 would fetch 10 results starting from the first result
LIMIT 50,25 would fetch results 50 through 75 (25 starting from 50)

So you can just run your SELECT query that fetchs all the records, and limit the results to 'pages' using LIMIT.

[skyphix]

Ah, this should greatly help me with my problem, thank you very much.

[[deleted]]

BTW: this method of deviding results into pages is also know as 'creating previous/next buttons' so if you search for those terms you will find lots of examples of how other people did this.

good luck!

[skyphix]

The way I've created Previous/Next buttons for the way the image gallery is now (no thumbnails, just have to click through all the images) is by using something like...

<?php
$PreviousID = $id - 1;
$NextID = $id + 1;
?>

$id having been pulled from the corresponding field in the database.
Then simply putting a link like...

<a href="?page=gallery&id=<?php print("$PreviousID") ?>">\\ back \\</a> &nbsp;&nbsp;|&nbsp;&nbsp; <a href="?page=gallery&id=<?php print("$NextID") ?>">// next //</a><br>&nbsp;

For the thumbnails I will probably have to use the way you described... thank you very much for your help!