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