[PHP-WIN] Re: results over multiple pages

2002-05-06 Thread Matt Parlane
I don't think SQL Server supports the LIMIT statement (this isn't MySQL remember...) >From memory SQL Server uses the TOP statement - something like "SELECT TOP 5 " although I'm probably wildly off as far as syntax goes. You can also use a percentage for the number of rows you want. Hope that he

[PHP-WIN] Re: results over multiple pages

2002-05-06 Thread Hugh Bothwell
> if ($currentPage > 1) { > $host="localhost"; > $DB="testDB"; > $user="sa"; > $pass=""; Umm... if that's the only place you use these values, why not specify them inline? Easier to read, for sure. > $connect = mssql_connect($host,$user,$pass) or die ($host." not > accessible."); > if ($DB) ms