Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-03 : 09:50:15
|
| Dean writes "I am programming a website in PHP on a Windowsserver. I am using MSSQL 2000 server as my database.The site I am building is a home rental site.Basically the site is mostly done but I can't figureout how exactly to break up my listing onto variouspages. I'm used to connecting to MySQL databases andthere is a command called offset which you can specifya place in the rows returned that it would start.Combine that with a 'limit' command ('top' in MSSQL)and you can just show like homes 30-39. I also wantto list the pages below and send a value on thatoffset to the query. I am building the site at:http://www.we-rent-homes.com and I have two needs tobreak up the listing onto pages. One is in the homelisting, and one is in the admin member listingsection. You can see it at:http://www.we-rent-homes.com/admin/members.php. Ihave the basic page counting in place, but I am havinga problem because the data is not consistant. Homesand members can be deleted so my unique identifier isnot consistant. In other words, there are gaps in thedata so my query can't just be 'WHERE id >=30 AND id <40'.My Email address is dean@adoption.com and any helpwould be appreciated! Thanks for your input. :)" |
|
|
Jay99
468 Posts |
Posted - 2002-04-03 : 10:24:30
|
| Does this help?Jay<O> |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
SQL2000