Hi Harpeet,
Try using PEAR::Pager http://pear.php.net/package/Pager
Regards,
Firman
- Original Message -
From: "Harpreet" <[EMAIL PROTECTED]>
To: "[PHP-WIN]" <[EMAIL PROTECTED]>
Sent: Wednesday, March 10, 2004 11:25 PM
Subject: [PHP-WIN] Paging using PHP and sql server
> I have cre
]
Subject: RE: [PHP-WIN] Paging using PHP and sql server
With SQL server you have to do something like
select top $number id from tablename
...
where id not in (select top $offset id from tablename)
where $number is the number of results you want and $offset is the offset
(surprisingly) The
ays, but with this I am sure you spin off and find the
solution that fits you the best.
-Original Message-
From: Harpreet
To: [PHP-WIN]
Sent: 10-3-2004 17:35
Subject: RE: [PHP-WIN] Paging using PHP and sql server
I am using sql server and it does not support limit funtion
-Original M
everything but the number of rows you are selecting.
-Original Message-
From: Harpreet [mailto:[EMAIL PROTECTED]
Sent: 10 March 2004 4:35
To: [PHP-WIN]
Subject: RE: [PHP-WIN] Paging using PHP and sql server
I am using sql server and it does not support limit funtion
-Original Message
I am using sql server and it does not support limit funtion
-Original Message-
From: David Felton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 11:27 AM
To: Harpreet; [PHP-WIN]
Subject: RE: [PHP-WIN] Paging using PHP and sql server
Check out this tutorial:
http
Check out this tutorial:
http://www.phpnoise.com/tutorials/9/1
-Original Message-
From: Harpreet [mailto:[EMAIL PROTECTED]
Sent: 10 March 2004 4:26
To: [PHP-WIN]
Subject: [PHP-WIN] Paging using PHP and sql server
I have created a few reports using sql server and PHP. The reports work ju
