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.

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

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.