MYSQL HowTo Get Display Select Show Data Starting With Letter Alphabet Only

hay dear u have to create the alphabets through a php loop and have to add a link to thes alphabets,
then u have to pass the alphabets as a url(get) and u must save the page names in the database so use the following query then it will show all the names of the pages from the database
select * from `products` where `page_name` like'$_get['pagename']%'

Can you write the whole code please?
Thank you!

to display your data from mysql database on an alphabetic pagination setup is easy.

I also read alot of forums but nothing gave me the answer, finally, i remembered this webiste, you can search wallpaper in alphebetical order by a specific letter only (starting with a certain letters in the alphabet)

For example, if you havea directory of services, and you want to have the links with the following letters: A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

I will show you how to do this, if you are breaking my head trying to figure out how to do this, the answer is simple.

use the LIKE '$letter%' in mysql command:

So to show the data after a user click on a link with the letter, i will run the following mysql Select variable:



that's it, the key here is - this is what makes all the magic happen

the '$letter%' tells mysql that i want anything that starts with the $letter.

so lets say i want only the data with the $letter at the begining, this would work fine

but how about if i wanted only the data with ending with the $letter, then i would use this:

NOTE: all i basically did was change the % to the beginning instead at the end.


Thanks to the folks at www.webune.com for their support, they were able to explain this to me.

If you need mysql / php hosting, we recommend you sign up with them, they are very helpful and have excellent support. the rely to my questions in no more than 15 minutes, i like that.