returning so much from a db

Hey.. I have a Database / PHP question... more sql than anything I am hoping.

I have a number of records in a database. My SQL select statement will return 102 records and I want to display 50 of them at a time. There is a button and when that is pressed it will select the next 50 and display those... then the last 2.

I didn't know if there was someway to tell the database you want the first 50 records... or the 50th record through the 100th record recieved. My unique key is not numberic so I can't do any of those tricks.

thanks,
Brandon

If you are using a MySql database, you can use limit to obtain the result set you require:

Code:

---

SELECT whatever FROM whatever LIMIT 49,100

---

Will return all records from number 50 to number 150.

COOL! That is what I was looking for.

I am using ODBC to connect to and ACCESS Database. Do you know if there is support for this?

Thanks again,
brandito

I'm not sure whther it will work. You are probably best asking that question in the Database forum.