[PHP-DB] Displaying next ten items

I am wondering what the mySQL commands are to display the next 10 records / previous 10 records. I am wondering how you pass a variable through a PHP script so the script knows which next or previous 10 entries to display. (Especially since this is all variable driven) Would you do something

Re: [PHP-DB] Displaying next ten items

Ron Piggott (PHP) wrote: I am wondering what the mySQL commands are to display the next 10 records / previous 10 records. I am wondering how you pass a variable through a PHP script so the script knows which next or previous 10 entries to display. (Especially since this is all variable

[PHP-DB] 10 rows

I would normally just pass the offset through the get var. I understand what you are saying in concept ... but what would a sample command be like? a href=http://www.host.com/script.php?next=21;Next Link/a a href=http://www.host.com/script.php?previous=1;Previous Link/a Ron

Re: [PHP-DB] Apache 2.2 + PHP5.2 + php_oci8.dll

Hi Chris, I read the write out and found that oracle 10g client only support 9i and above. So I assumed that it will not work with mine server runing on oracle8i (8.1.5) with 8 compatible set. Hence, I didn't try to install the 10g client for any testing. I will get it download later to have a

[PHP-DB] Re: 10 rows

Ron Piggott (PHP) wrote: I would normally just pass the offset through the get var. I understand what you are saying in concept ... but what would a sample command be like? a href=http://www.host.com/script.php?next=21 http://www.host.com/script.php?next=11Next Link/a a