Yes, that will indeed return the rows specified, but the result is very unstable. By it's nature, MySQL does not have to conform to any sorting method unless you specify it. So it's very good practice when retrieving multiple rows to ALWAYS order them. Just my thoughts :o)
Martin >>> "Tech Support" <[EMAIL PROTECTED]> 07/25/02 12:09PM >>> This query will return only the 16th row SELECT firstname FROM table_name LIMIT 16, 1 This query will give you all rows up to 15 SELECT firstname FROM table_name LIMIT 1, 15 Jim Grill Support Web-1 Hosting http://www.web-1hosting.net ----- Original Message ----- From: "Tyler Durdin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 25, 2002 10:18 AM Subject: [PHP] pulling records from mysql > I have a column in my table named firstname with twenty records in it. How > can i use php to pull out individual records (say for ex. record 16)? Also, > how could i pull out all records upto number 15? Thanks in advance. > > > > _________________________________________________________________ > Send and receive Hotmail on your mobile device: http://mobile.msn.com > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php