Re: [PHP-DB] Web page paginator that doesn't rely on the LIMIT clause

2004-08-03 Thread Justin Patrin
On Tue, 03 Aug 2004 20:52:23 +1000, Ross Honniball <[EMAIL PROTECTED]> wrote: > Hi all, > > I use the LIMIT statement to control paging of data, which works really well. > > I now have a situation where I need to use some logic in addition to the > query that will result in NOT ALL records being

Re: [PHP-DB] Web page paginator that doesn't rely on the LIMIT clause

2004-08-03 Thread Ross Honniball
- Original Message - From: "Ross Honniball" <[EMAIL PROTECTED]> To: "php DB" <[EMAIL PROTECTED]> Sent: Tuesday, August 03, 2004 2:54 PM Subject: Re: [PHP-DB] Web page paginator that doesn't rely on the LIMIT clause > At 10:22 PM 3/08/2004, you wro

Re: [PHP-DB] Web page paginator that doesn't rely on the LIMIT clause

2004-08-03 Thread Ignatius Reilly
n-hand to decide if I want to 'output' the record or not. > > Let me know if you want more detail. It would resolve the present issue if > it can be done in a query(and improve my sql knowledge). > > >_________________ > >- Original Message - >

Re: [PHP-DB] Web page paginator that doesn't rely on the LIMIT clause

2004-08-03 Thread Ross Honniball
Message - From: "Ross Honniball" <[EMAIL PROTECTED]> To: "Ignatius Reilly" <[EMAIL PROTECTED]> Sent: Tuesday, August 03, 2004 1:46 PM Subject: Re: [PHP-DB] Web page paginator that doesn't rely on the LIMIT clause > thanks ignatius. not sure i'm out of

Re: [PHP-DB] Web page paginator that doesn't rely on the LIMIT clause

2004-08-03 Thread Ignatius Reilly
t; <[EMAIL PROTECTED]> To: "php DB" <[EMAIL PROTECTED]> Sent: Tuesday, August 03, 2004 12:52 PM Subject: [PHP-DB] Web page paginator that doesn't rely on the LIMIT clause > Hi all, > > I use the LIMIT statement to control paging of data, which works really well.

[PHP-DB] Web page paginator that doesn't rely on the LIMIT clause

2004-08-03 Thread Ross Honniball
Hi all, I use the LIMIT statement to control paging of data, which works really well. I now have a situation where I need to use some logic in addition to the query that will result in NOT ALL records being spat out. ie. select * from x where y; foreach result if (some condition) outp