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:[EMAIL PROTECTED]]
Sent: Saturday, June 30, 2001 10:30 AM
To: [EMAIL PROTECTED]
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
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
