Re: search in alphabetical order

[Gordon Leonard <gordon.leonard@xxxxxxxxxxxxxx>]

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]