I think you are asking:
"If I grab data from 9 rows in the db, how can I show the first 3 rows on the first page, the next three rows on the second page, and the last three rows on the third page?"
Look at LIMIT in the MySQL manual. If I remember correctly, the syntax is something like:
SELECT fields FROM tables [WHERE conditions] LIMIT [first_record,]number_of_records
So LIMIT 3 would get the first 3 rows.
LIMIT 3,3 would get rows 4, 5, & 6. I think. Look at the manual to be sure.
