RE: [PHP] Dynamic List Using Php

So the select will be generated from values in the db? here is an example of something I did.. print" <br>City:<br>"; print" <select name='city'>"; $result2=mysql_query("SELECT distinct(city) from listings where approved=1 and state='$state' and country='$country'"); while ($myrow2 = mysql_fetch_array($result2)){ print "<OPTION>" . $myrow2["city"]; } print "</select><br><br>"; Eddie -----Original Message----- From: Pushpinder Singh Garcha [mailto:pgarcha@adelphia.net] Sent: Tuesday, January 21, 2003 2:10 PM To: php-general@lists.php.net Subject: [PHP] Dynamic List Using Php Hello All I am wanting a create a dynamic List using php. When a user enters a value on a form, I need the value that he entered on the form to added to a dynamic list box, which is displayed on the next page. So the List Box continues to grow whenever a user adds a value on the form (note: The values entered every time have to be stored) Thanks in advance. Pushpinder Singh Garcha _________________________________ Web Architect T. Falcon Napier and Associates, Inc. _________________________________