You want to use “LIKE A%” will show everything that starts with A I use it like this: SELECT * FROM `database` WHERE `database field` LIKE '$start_here%' Where $start_here is the letter they clicked on. From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of Chris Cupas Sent: Friday, March 23, 2012 7:53 PM To: php-objects@xxxxxxxxxxxxxxx; bang-phpug@xxxxxxxxxxxxxxx Subject: Re: search in alphabetical order If you are using MySql you can try ORDER by Statment. e,g. Select Fieldname from Tablename ORDER by fieldname - by default the Order by is set to "ASC" or Ascending Order you can set it to "DESC" or Descending Order Reference manual here: http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html ________________________________ From: vijaya lakshmi <vijayalakshmi6jun@xxxxxxxxx <mailto:vijayalakshmi6jun%40gmail.com> > To: php-objects@xxxxxxxxxxxxxxx <mailto:php-objects%40yahoogroups.com> ; bang-phpug@xxxxxxxxxxxxxxx <mailto:bang-phpug%40yahoogroups.com> Sent: Friday, March 23, 2012 8:59 PM Subject: search in alphabetical order hi, Please guide me on how to code to search elements from database in alphabetical order. If we click on A all items starting from A get displayed. -- Thanks & Regards VijayalakshmiPrasanna [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]