Here is some code that I like to use. I mix real code and psuedo code cause
I'm more used to just using the db class from PHP Lib.
First get a count of how many records there are.
$sql = "SELECT count(*) as c FROM users";
Then read that count into variable $count.
Declare a variable which will
Hi,
First you'll have to modify your query to show only ten rows.
$sql = "SELECT id, email, name, subject, url, image2, comments, dat
FROM users
ORDER BY id DESC LIMIT $start,10";
The $start variable shows the number of the first row to show
The links for the previous and next