works like a bomb !!! thanx man ! "Torsten Roehr" <roehr@xxxxxxxxxxx> wrote in message news:20040609174612.92107.qmail@xxxxxxxxxxxxxxx > "Gamco - Gawie Marais" <gawie@xxxxxxxxx> wrote in message > news:200406091404.i59E4TjH007936@xxxxxxxxxxxxxxxxxxxxxx > > Hi, > > > > Could someone help me out here... > > > > I have a mysql database with a table that conatains names. I am setting up > a > > html form and I would like to create a multi-listing with those names so > > that you can choose one and then submit the form. > > > // open db connection... > > $result = mysql_query("SELECT name FROM table"); > > echo '<select name="names">'; > > while ($row = mysql_fetch_assoc($result)) { > > echo '<option>' . $row['name'] . '</option>'; > } > > echo '</select>'; > > Haven't tested it. Change 'name' to the name of your table column. > > Regards, > > Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
