Re: [PHP] Database Paging using MSSQL 2000

2001-02-24 Thread Manuel Lemos
Hello Ankur, On 21-Feb-01 06:09:04, you wrote: >I am implementing a database application using PHP4 and MSSQL2000. I have a >database table which has a large no. of tuples. I want to display the data in >the form of pages with Prev Next buttons. >I wanted to know if there is some syntax in the

Re: [PHP] Database Paging using MSSQL 2000

2001-02-23 Thread Richard Lynch
>I wanted to know if there is some syntax in the MSSQL Select statement which can allow me to >limit the no. of records being returned. I am lookin at functionality which is similar to >LIMIT in Mysql. Look up "cursor" in your MS SQL documentation. It's not as mind-numbingly simple as LIMIT, but

[PHP] Database Paging using MSSQL 2000

2001-02-21 Thread Ankur Verma
Hello All! I am implementing a database application using PHP4 and MSSQL2000. I have a database table which has a large no. of tuples. I want to display the data in the form of pages with Prev Next buttons. I wanted to know if there is some syntax in the MSSQL Select statement which can allow