Form with drop down list from query
Posted: Thu Feb 25, 2010 6:47 am
I am trying to design an input form based on a drop down list which uses an sql query as its source.
The following Query staement produces a drop down list but so far I have been unable to incorporate POST and Submit statements to allow me to pass the selected variable .
Code so far :-
<?
$username="uname";
$password="pwd";
$database="my_db";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$result = mysql_query('SELECT * FROM `daysofweek`') or die(mysql_error());
echo '<select name="Day">';
while ($row = mysql_fetch_assoc($result)) {
echo '<option value="'.$row['1'].'">'.$row['Day'].'</a>';
}
echo '</select>';
?>
Can anyone suggest the appropriate structure to create the form.
Thanks
Dave
The following Query staement produces a drop down list but so far I have been unable to incorporate POST and Submit statements to allow me to pass the selected variable .
Code so far :-
<?
$username="uname";
$password="pwd";
$database="my_db";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$result = mysql_query('SELECT * FROM `daysofweek`') or die(mysql_error());
echo '<select name="Day">';
while ($row = mysql_fetch_assoc($result)) {
echo '<option value="'.$row['1'].'">'.$row['Day'].'</a>';
}
echo '</select>';
?>
Can anyone suggest the appropriate structure to create the form.
Thanks
Dave