Question dynamic drop-downs.

[scm24]

Two questions on this, first apparently I am missing a bracket somewhere because the "mysql_close();" statement and "?>" show up on my page....can I get a little help here?

Second, in the dropdown I would like to send the user to a specific page once they choose "Add to List". I have 2 dropdowns and 2 different pages to send them too, based upon what option/dropdown they choose. What's the best way to do this?

Thanks in advance.

Steve

<?

$username="masked";
$password="masked";
$database="masked";

mysql_connect(localhost,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");

$query = "SELECT Race FROM tblRace";
$result=mysql_query($query);

$query1 = "SELECT concat_Name FROM tblRunner";
$result1=mysql_query($query1);

<form action= "race-result_handle.php" method="GET">

Runner's Name: <select name=\"Runner_Name\">
if(mysql_num_rows($result1))
{
// we have at least one user, so show all users as options in select form
while($row = mysql_fetch_row($result1))
{
print("<option value=\"$row[0]\">$row[0]</option>");
}
}
else
{
print("<option value=\"\">Add to List</option>");
}
</select>
</BR></BR>

Race Name: <select name=\"Race_Name\">
if(mysql_num_rows($result))
{
// we have at least one user, so show all users as options in select form
while($row = mysql_fetch_row($result))
{
print("<option value=\"$row[0]\">$row[0]</option>");
}
}
else
{
print("<option value=\"\">Add to List</option>");
}
</select>

</BR></BR>

<Input type = "Submit" Name = "Submit1" VALUE = "Search">
</form>

mysql_close();

?>

[Kudose]

I don't know how your script even works since you go in and out of PHP and HTML without regard to tags at all.

Also, try using the [ PHP ] tags when posting code.

Try this code:

<?

$username="masked";
$password="masked";
$database="masked";

mysql_connect(localhost,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");

$query = "SELECT Race FROM tblRace";
$result=mysql_query($query);

$query1 = "SELECT concat_Name FROM tblRunner";
$result1=mysql_query($query1);

echo '<form action= "race-result_handle.php" method="GET">';

echo "Runner's Name: <select name=\"Runner_Name\">";
if(mysql_num_rows($result1))
{
// we have at least one user, so show all users as options in select form
while($row = mysql_fetch_row($result1))
{
print("<option value=\"$row[0]\">$row[0]</option>");
}
}
else
{
print("<option value=\"\">Add to List</option>");
}
echo '</select><br /><br />';

echo 'Race Name: <select name=\"Race_Name\">';
if(mysql_num_rows($result))
{
// we have at least one user, so show all users as options in select form
while($row = mysql_fetch_row($result))
{
print("<option value=\"$row[0]\">$row[0]</option>");
}
}
else
{
print("<option value=\"\">Add to List</option>");
}
echo '</select><br /><br />';

echo '<input type = "Submit" Name = "Submit1" VALUE = "Search">
</form>';

mysql_close();

?>

[Kudose]

Also, use [man]header[/man] or a meta refresh to redirect the user after your form is submit.

[scm24]

OK, the proposed solution of adding "echo" tags didn't work.

So, what do you propose now, should I just use HTML tags for building the form and JavaScript for accessing the mySQL database to dynamically build the drop-downs?

Thanks in advance.

[bradgrafelman]

What do you mean by "didn't work" ? Can you show us the HTML that was outputted?

[Roger_Ramjet]

It is not neccessary to use mysql_close() at the end of your script because that will happen anyway as soon as the script terminates.

[scm24]

See the attached for the output.