Forum Moderators: coopster
my database is: access.
table: select.
field: code.
<html>
<body>
</select>
<form method="POST" action="access2.php">
<p> <a href="form3.html">FORM1</a> ¦
<a href="test.html.php">TEST</a></a> </p>
<p> </p>
<p>
<font size="4"><b> Industry Number
<input type="text" name="code" size="20"></b></font></p>
<p><font size="4"><b>
for issue
<select size="1" name="select">
<?
$link = mysql_connect()
or die('Could not connect: '. mysql_error());
mysql_select_db('access') or die('Could not select database');
$query = "SELECT `code` FROM `select` ";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
while ($row = mysql_fetch_array($result,MSSQL_ASSOC)){
echo "<option >.$row['code'].</option>";
}
?></b></font></select></p>
<p><font size="4"><b>
If Other Specify
<input type="text" name="specify" size="20"></b></font></p>
<p><font size="4"><b>
</b></font></p>
<p>
<input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>
</body>
</html>
[edited by: jatar_k at 1:54 pm (utc) on Mar. 17, 2008]
[edit reason] removed many nbsp for clarity [/edit]
<?php
$link = mysql_connect() or die('Could not connect: '. mysql_error());
mysql_select_db('access') or die('Could not select database');
$query = "SELECT `code` FROM `select` ";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
?>
<select size="1" name="select">
<?php
while ($row = mysql_fetch_array($result,MSSQL_ASSOC)){
echo "<option >".$row['code']."</option>";
}
?>
</select>
