> Here is my table > > ID ----Primary Key > name-----varchar(15) > bloodtype-----varchar(15) > > What I would like to do is on the first sheet select the first 30 records > and on the second sheet select the next 30 records so on and so forth! > Any > ideas? Yes, search the archives or google for "prev next links" or something similar. There are a lot of tutorials out there discussing how to do this and it's discussed on the list quite a bit. If you have a specific problem please post again... ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php