Re: [PHP] eating mySQL result rows 1 by 1.. a better way?

2002-03-21 Thread Maris Kalnins
]... > - Original Message - > From: "Steve Clay" <[EMAIL PROTECTED]> > To: "PHP-GENERAL" <[EMAIL PROTECTED]> > Sent: Thursday, March 21, 2002 4:54 PM > Subject: [PHP] eating mySQL result rows 1 by 1.. a better way? > > > > On my site I pa

Re: [PHP] eating mySQL result rows 1 by 1.. a better way?

2002-03-21 Thread Joffrey van Wageningen
- Original Message - From: "Steve Clay" <[EMAIL PROTECTED]> To: "PHP-GENERAL" <[EMAIL PROTECTED]> Sent: Thursday, March 21, 2002 4:54 PM Subject: [PHP] eating mySQL result rows 1 by 1.. a better way? > On my site I paginate query results by limiting

[PHP] eating mySQL result rows 1 by 1.. a better way?

2002-03-21 Thread Steve Clay
Hello, On my site I paginate query results by limiting rows output to a value, say LIMIT, and then the 2nd, 3rd pages run the same query with $skip=LIMIT, $skip=(LIMIT*2) value posted back. I use the following code to "skip" these result rows, which is just fetching the next row to an unused arr