Re: MSSQL - Previous/Next Paging Results

> > -----Original Message----- > > MSSQL seems to be a little bit messier that MySQL..e.g limit clause etc > > > > Anyone know of articles/examples that specifically deal with this issue? > > Look into the Top() function for MSSQL. It goes something like: > > SELECT Top(10) * FROM table > > You should be able to find some info under the msdn.microsoft.com page. > Or, MS has several hundred newsgroups, they should have one for MSSQL. Use TOP in conjuction with mssql_data_seek() to get where you need. Since you can't specify a starting point with TOP like you can with LIMIT, you seek() to the starting point. All other concepts still apply. ---John Holmes...