Re: Dropdowns

On 31 May, Scott Iwamoto wrote: > > 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; Shouldn't that be something like echo '<option value="$publication">' . $publication; > } > ?> > </select> > <input type=submit name=submit> > </form> > </body> > </html> Cheers -- David Robley | WEBMASTER & Mail List Admin RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/ AusEinet | http://auseinet.flinders.edu.au/ Flinders University, ADELAIDE, SOUTH AUSTRALIA