I am a PHP programmer for a small startup. We are storing person records and our MS SQL Server 2000 database has grown to the point where we wish to paginate the data before returning it to my PHP scripts.
I was wondering if anyone has any recommendations on an optimal way to manage this given the following requirements.
- Data must return only X number of rows at a time (user configurable).
- Must be able to search by several diffent criteria (name, date, birthday, location, ...)
Also, I was wondering if it is possible to return the total number of existant rows of data as the first row of a MSSQL procedure.Originally posted by shauns
Also, I was wondering if it is possible to return the total number of existant rows of data as the first row of a MSSQL procedure.
What does that mean?
Did you do a search of this site? Either here or sql team (or both) I know we've bantered this one about a couple of times...|||Here's one link...
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=33472&SearchTerms=paging
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment