[PHP-DB] how to implement "pages" of results

2004-11-24 Thread ragan_davis
Hi, I'm sure this is a common question, so please forgive if it's been posted before. I have a select statement that selects records from a table: "select * from $table where host='$somename'" I then propagate a table with the returned data. My goal is to only display 30 records per "page", w

Re: RE: [PHP-DB] how to implement "pages" of results

2004-12-01 Thread ragan_davis
Thanks, guys. "limit $start, $range" works fine in conjuction with the $pagenum solution offered by Martin. I think my problem all along was that I was going under that assumption that the $start value was referring to the actual row number in the table, rather than the row number as found in