Use the LIMIT clause on your select statement Limit 0,10 will get first 10, then use limit 10,10 for the next 10, etc.
see http://www.mysql.com/doc/en/SELECT.html for details -----Original Message----- From: Jason Frisvold [mailto:friz@;corp.ptd.net] Sent: Friday, November 15, 2002 11:02 AM To: [EMAIL PROTECTED] Subject: Continuing a previous selection I want to select a large amount of data from the database, but I can't use it all at once. Is there a way to "pick up where I left off" and get another X rows of data? For instance, suppose I have the following table in a database : CREATE TABLE namelist (nameid INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, First_Name CHAR(50), Last_Name CHAR(50)) This table has 500 rows. I want to select the data, order it by last name, and limit the select to 10 rows at a time. After I display this data, I want to be able to go to the next 10 rows ... Or, perhaps view the data and select to jump 50 rows ahead ... My initial thought was to use the nameid field to do this, however, I cannot since I'm ordering the data.. There is no way to be certain that the order that comes out keeps the nameid values in order ... So how is this accomplished? I see it done all over the place, but I have no idea how to do this on my own ... The program that will be doing this is written in perl using the perl DBI and the mySQL DBD... Any help would be greatly appreciated...! -- --------------------------- Jason H. Frisvold Senior ATM Engineer Penteledata Engineering [EMAIL PROTECTED] RedHat Certified - RHCE # 807302349405893 --------------------------- "Something mysterious is formed, born in the silent void. Waiting alone and unmoving, it is at once still and yet in constant motion. It is the source of all programs. I do not know its name, so I will call it the Tao of Programming." --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php