Re: [PHP-DB] Limited number of database results

2006-12-13 Thread John Meyer
Niel Archer wrote: > Hi > > use a LIMIT clause in your SQL. Something like: > > $query="SELECT * FROM WHERE hello = '$hello' LIMIT " . ($page - 1) * > $rows . ", $rows"; > > then you only need specify the logic to set the page, row and > limitations > > You also typically need to use the

Re: [PHP-DB] Limited number of database results

2006-12-13 Thread Niel Archer
Hi use a LIMIT clause in your SQL. Something like: $query="SELECT * FROM WHERE hello = '$hello' LIMIT " . ($page - 1) * $rows . ", $rows"; then you only need specify the logic to set the page, row and limitations Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, v

RE: [PHP-DB] Limited number of database results

2006-12-13 Thread Bastien Koert
use the limit clause $count = 25; $query="SELECT * FROM WHERE hello = '$hello' limit $count"; Bastien From: Chris Carter <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] Limited number of database results Date: Wed, 13 Dec 2006 08:51:47 -0800 (PST) Hi, I have more than