RE: [PHP-GENERAL] Dropdowns
| From: | Sam Masiello | Date: | Thu, 01 Jun 2000 13:37:10 +0000 |
| Subject: | RE: [PHP-GENERAL] Dropdowns | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-791@lists.php.net to get a copy of this message | ||
You did not mention which errors you are getting, but the line:
while($publication = mysql_fetch_array($result) {
should read:
while($publication = mysql_fetch_array($result)) {
You are missing a right parenthesis to close your while statement before the
left brace.
Sam Masiello
System Analyst
Chek.Com
(716) 853-1362 x289
smasiello@chekinc.com
-----Original Message-----
From: Scott Iwamoto [mailto:scott@cns.queens.org]
Sent: Wednesday, May 31, 2000 10:57 PM
To: php-general@lists.php.net
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