Re: [PHP] PHP and Mysql Limit

2003-07-02 Thread ed
On Wed, 2 Jul 2003, Jeff Harris wrote: > Then, once you've done it enough times, $start = $count = 178. > [code] > while ($start <= $count) { > // when $start = $count = 178, you won't retrive any data > [/code] The recordset would not alway contain an even number of records resulting in 10 re

Re: [PHP] PHP and Mysql Limit

2003-07-02 Thread ed
t;[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, July 02, 2003 9:23 AM > Subject: [PHP] PHP and Mysql Limit > > > > > > I've created a script that reads a sorted mysql query and outputs specific > > results into text files defined by th

Re: [PHP] PHP and Mysql Limit

2003-07-02 Thread Jeff Harris
|- Original Message - |From: <[EMAIL PROTECTED]> |To: <[EMAIL PROTECTED]> |Sent: Wednesday, July 02, 2003 9:23 AM |Subject: [PHP] PHP and Mysql Limit | | |> |> I've created a script that reads a sorted mysql query and outputs specific |> results into text file

Re: [PHP] PHP and Mysql Limit

2003-07-02 Thread Chris Sherwood
It looks like your adding 10 to 8 thus getting 18... of course I maybe looking at this wrong - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 02, 2003 9:23 AM Subject: [PHP] PHP and Mysql Limit > > I've created a scr

[PHP] PHP and Mysql Limit

2003-07-02 Thread ed
I've created a script that reads a sorted mysql query and outputs specific results into text files defined by the start and limit of mysql. The database holds 178 records. I want to start my output on #9 with 10 records per page. Should leave me with 17 equal pages right? $count = 178 $start = 8;