Re: [PHP] Re: limit items per page

2001-07-23 Thread Martin Cameron
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 firs

[PHP] Re: limit items per page

2001-07-23 Thread James Holloway
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 mys

[PHP] Re: limit items per page

2001-07-23 Thread Henrik Hansen
[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 comman

[PHP] Re: limit items per page

2001-07-23 Thread James Holloway
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, startin