getting a letter from a word

hello

i want to create 26 pages or however many letters there are in the alphabet.

page 1. (page.php?page=a)
page 2. (page.php?page=b)
page 3. (page.php?page=c)

i have a database with about 2000 words in it. in page=ai want to print all the word begining with the letter A for example.

my question is, does anyone know how i could get the first letter of (phpbuilder)
which would be (p)

im using php/mysql database.

any help would be much appreciated.

To get the first letter you could use substring():

$first_letter = substr ($some_word, 0, 1);

thanks.

any idea how i can say to MySQL to only display words starting with that letter?

i.e.
i want pages a-z

I'm not much into MySql, but maybe this works. Example of query to get all pages starting with 'a':

SELECT page FROM some_table WHERE page LIKE "a%";

that works.

🙂

thanks man.