There are two ways. In MS SQL server 7.0 you can do SELECT TOP <#> ....
If you are on 6.5, then you need to do set the row count environ variable, e.g something like "set rowcount <#>" -----Original Message----- From: disko_kex To: [EMAIL PROTECTED] Sent: 2003-07-02 19:20 Subject: [PHP-WIN] MSSQL HELP In MySQL is easy to page with LIMIT but it doesnt work with MSSQL. So how do I make it page in MSSQL? -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
