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
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
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