Re: [PHP-DB] Paging help needed :-(

2001-07-12 Thread Roger Ramirez
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

Re: [PHP-DB] Paging help needed :-(

2001-07-11 Thread Dobromir Velev
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