Re: LIMIT
| From: | Doug Semig | Date: | Thu, 29 Jun 2000 20:40:24 +0000 |
| Subject: | Re: LIMIT | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-759@lists.php.net to get a copy of this message | ||
You have to change your LIMIT clause to page through the different rows...
SELECT ... LIMIT 0,5 gives you rows 0 through 4
SELECT ... LIMIT 5,5 gives you rows 5 through 9
SELECT ... LIMIT 10,5 gives you rows 10 through 14
and so on
Take a peek at http://web.mysql.com/documentation/manual.php?section=SELECT
for more information.
Doug
Torsten Curdt was heard at 07:37 PM 6/29/00 +0200 to say:
>When quering:
>
>SELECT * FROM tblArtikel ORDER BY artID LIMIT 0,5
>
>"mysql_num_rows" always yields 5! But how can I getALL
>affected rows? I tried "mysql_affected_rows" but this
>still gives me always 5!
>
>I like to implement a paging mechanism
>(prev,next, etc.)
>--
>Torsten