Re: Dropdowns

Hi there, when you add options to the select tag you have to start a new line for every option, meaning that you need to add in the end of your echo the "\n" in order to force a new line in the source of the HTML. Otherwise, the whole output will be given in one line. Hope I helped! David. ----- Original Message ----- From: Scott Iwamoto <scott@cns.queens.org> To: <php-general@lists.php.net> Sent: Thursday, June 01, 2000 5:56 AM Subject: [PHP-GENERAL] Dropdowns > > I am trying to make a dropdown from values in a table but I keep > getting errors. I have checked a number of the archives. I found > various functions that are supposed to do this yet I just cant seem > to get it to work. > > Any help/tips would be greatly appreciated. It would help to see the > full source of a working copy so I can get a better understanding of > how it works. =) Thanks. > > > I tried to break it down to something simple but even this does not > seem to work. > > > <html> > <head> > <title Array into SELECT dropdown </title> > </head> > <body> > <?php > > $user = "phpuser"; > $password = "phppassword"; > $host = "localhost"; > $table = "publications"; > $database = "publications"; > ?> > > <form method="post" action="mysql_test.php3"> > <select name="publication"> > <? > mysql_connect($host, $user, $password); > > $result = mysql_db_query($database, "select str_publication from publication"); > > while($publication = mysql_fetch_array($result) { > print "<option>". $publication; > > } > ?> > </select> > <input type=submit name=submit> > </form> > </body> > </html> > > > > > > > > > Scott T. Iwamoto, Coordinator Departmental Information Systems, > Research Planning & Development, The Queen's Medical Center > 1356 Lusitana St. 8th Floor, Honolulu, HI 96813 > (808) 537-7937 Fax: (808) 537-7898 > http://www.d2p.queens.org > > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >