Pages?

[Serge]

I currently have this query running

[SQL]
$temp = $DB_site->query("SELECT id, address, date, username, userid, description, hits FROM links WHERE catid=$catid && verify=1 ORDER BY date DESC LIMIT $limit");
[/SQL]

Ok so say $limit was set to 5 and it turns out that there are 10 entires how would I advance to a new page inside PHP.

All I have got so far is getting the variable from the address bar and then running an if statement to check to see if page is set but how would that query look say if I wanted page 2?

[filburt1]

The LIMIT keyword can take two arguments: a starting index and a length, or just a length. See the documentation for SELECT for details.