RE: [PHP] reading records alphebetically

If you are planning to have a lot of records, you may want to create a column with just that letter and index it, followed by the full name. SELECT name from Table WHERE first_letter = "$letter" ORDER by name should produce pretty fast results if "first_letter, name" is indexed. Warren Vail -----Original Message----- From: Jamie Saunders [mailto:jamie.s@btinternet.com] Sent: Saturday, June 30, 2001 10:30 AM To: php-general@lists.php.net Subject: [PHP] reading records alphebetically Hi, I have a MySQL database set-up containing a few hundred records. I'm trying to make a script that reads the 'name' field of the records and displays only the records of which the name field begins with a specific letter: if ($letter = A) { display all records of which field 'name' beings with A } else if ($letter = B) { ... I'm just starting out on this, so please excuse my ignorance :) Jamie Saunders jamie.s@btinternet.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net