search form with alphabetical order

[liza_nc]

Hi all,

I want to use advanced search with dropdown box which has all the products on my site written with php, but i want to give the user the facility to choose the product by alphabetical order, choose letter A give him all produts starts with "A" and so on....
(these products are selected form sql database)

please, see the attached image that describe what i mean.

I need help as i don't know completely how to do that.

Thanks.

[nikesh.yadav]

u can use ajax
and call query on click and where condition will be as " where productname like "a%" and "b%" and so on

[liza_nc]

Thank you for your replay, but I'm not good with ajax, I know this can be done with ajax but i don't kow how, if you can give me tutorial to how to implement this, i'd be grateful.