SiaMensiS Posted January 14, 2010 Share Posted January 14, 2010 I'm trying to figure out how to do it so that when a user clicks on a certain letter of the alphabet that has been listed, how does I get it to list everything in that column that begins with that letter i.e they click on the A, and it lists everything in that column that the letter is A So apple will be listed, but no Banana, also non case-sensitive. Thanks Quote Link to comment Share on other sites More sharing options...
killerb Posted January 14, 2010 Share Posted January 14, 2010 <?php $query = "SELECT * FROM tablename WHERE colname LIKE '{$letter}%'"; Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.