Dropdowns
| From: | Scott Iwamoto | Date: | Thu, 01 Jun 2000 02:56:30 +0000 |
| Subject: | Dropdowns | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-767@lists.php.net to get a copy of this message | ||
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