[PHP] Re: limit items per page

Hi Steph, as the name suggests, use LIMIT ;) Ie, SELECT * FROM TABLE LIMIT 0,25 The 0 (or other number) is optional, and tells the table which row to start limiting from, the secon number is the number of rows to limit to.. So: SELECT * FROM TABLE LIMIT 25,25 Would bring out 25 rows,

[PHP] Re: limit items per page

[EMAIL PROTECTED] (James Holloway) wrote: Hi Steph, as the name suggests, use LIMIT ;) AFAIK it's mysql specific (at least it does not work with mssql) -- Henrik Hansen -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

[PHP] Re: limit items per page

Perhaps I shouldn't have made the assumption that steph was using mysql :) Henrik Hansen [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... [EMAIL PROTECTED] (James Holloway) wrote: Hi Steph, as the name suggests, use LIMIT ;) AFAIK it's mysql specific

Re: [PHP] Re: limit items per page

Here's a Quick Dirty script that I ran up to get a display of 10 items per page with each click on a hyper-linked page returning a new page .. if you know what I mean. I've even included the headers so that any newbies can see the complete script and not just bits. The theory is that the