# How to choose multiple values with dropdown lists from SQL database?

**URL:** <https://forum.kirupa.com/t/how-to-choose-multiple-values-with-dropdown-lists-from-sql-database/226313>\
**Category:** Uncategorized\
**Created:** [May 20, 2007, 3:41am UTC](https://forum.kirupa.com/t/how-to-choose-multiple-values-with-dropdown-lists-from-sql-database/226313 "2007-05-20T03:41:21Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![nitin\_2k1](https://avatars.discourse-cdn.com/v4/letter/n/d26b3c/32.png) [@nitin\_2k1](https://forum.kirupa.com/u/nitin_2k1)\
**Post date:** [May 20, 2007, 3:41am UTC](https://forum.kirupa.com/t/how-to-choose-multiple-values-with-dropdown-lists-from-sql-database/226313/1 "2007-05-20T03:41:21Z")

</div>

also i am stuck with another problem.  
i am trying to make a search page where people can search based on the city and the category using dropdown menus…

i have already created a database of city , category and merchant

so when the user selects the city and the category from dropdown menu list of merchant appears of that particular city and category.

just like this website [www.customerdeal.com.au](http://www.customerdeal.com.au/) when you go to search you see what i mean (by the way i know this website sucks but its just the same search thing i am trying to do in my website).

regards,  
:tie: