using LIMIT
| From: | Sharmad Naik | Date: | Fri, 06 Apr 2001 11:18:20 +0000 |
| Subject: | using LIMIT | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-8310@lists.php.net to get a copy of this message | ||
Hi,
Thanks for firstly helping me out with the prevoius query.
I have a database with mem_id(int) and name(text) as its fields.
In the first form (HTML) ,I take mem_id,name and count(used for LIMIT)
from the browser.
In the second query i write a query whereby i say
$result=pg_Exec($database,"SELECT mem_id,name from search LIMIT $count");
Now here i display the the first 10(say $count=10) records.
Now I know to display the other records i can say
$result=pg_Exec($database,"SELECT mem_id,name from search LIMIT $count,$count");
but what condition to give to display pages of more than $count records
i.e how do i give for next existing page.
--
The secret of the universe is @*&í!'ñ^#+ NO CARRIER
__ _ _ _ _
|_|_||_||_||\/||_|| \
_|| || || \| || ||_/