The guy really should try google For this kind of question Sent from my iPhone On 24 Mar 2012, at 00:39, "Chris ODonnell" <chrisod@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote: > 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] > > [Non-text portions of this message have been removed]
