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> To: php-objects@xxxxxxxxxxxxxxx; bang-phpug@xxxxxxxxxxxxxxx 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]