php-db | 2001011

[PHP-DB] Need to send a variable to part of a MySql query From: Dave Carrera (dave <email protected>)
Date: 01/04/01

Hi All
Thanks JB for the link to get info about creating a dropdown list populated
with the contents of a field in my DB.

Now I need to send the selected item from the dropdown list created to a
query.

In other words my visitor selects lets say London from my created list and
London is then included in a query to select all from my table that inc
London.

In my db the town name is a must have field but my created list show ALL
instances of the town name, so my dropdown list looks something like this..

Choose a town
London
London
London
Cardiff
Dover
Dover

What I would like to know is how I can just show 1 instance of a towns name
if multiple exist in my db so the list looks like this...

Choose a town
London
Cardiff
Dover

Names used only for demonstration...

Any pointers or direct help with this is most appreciated.

Dave ;-) 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>