> is there a function that will extract the first character from a mysql > result and put it into a variable?
you can do it directly in SQL: select * from TABLE_NAME where FIELD_NAME like 'A%' for all names beginning by 'A' cheers, Valter Santos ----- Original Message ----- From: "Mateo the DB guy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 05, 2001 6:49 PM Subject: [PHP-DB] sorry...probably too easy > i'm fairly new to php, and thank you in advance for helping. > is there a function that will extract the first character from a mysql > result and put it into a variable? > the goal is to make one of these browse-by-alpha lists > > ABCDEFGHIJKLMNOPQRSTUVWXYZ > A > Adam > Alethea > Arnie > B > Billy > Buster > ... > > where all the names come from the mysql query, and the anchors are > automatically built where they need to be. > > > -- > PHP Database 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 Database 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]