Additional values in select

[ndorfnz2]

Looking for some help on how to accomplish the following:

Currently populating a select box based on values in a mysql database.

// create SQL statement for YEARS
$years_sql = "SELECT distinctrow year FROM races where workout_type = 'Race'";
// execute SQL query and get result
$years_sql_result = mysql_query($years_sql,$con)
or die("Couldn't execute query.");
// put data into ARRAY box FOR years select box
while ($rowY = mysql_fetch_array($years_sql_result))
{
$years = $rowY[year];
$years_block .= "<OPTION VALUE=\"$years\">$years</OPTION>";

}

echo "<Select name=yearsel>";
echo $years_block;
echo "</select>";
echo " and ";

I want to have the option to select a value of "ALL YEARS", this DOES NOT exist in the database. I plan to have this selection kick off another set of SQL code.

So... how do I get the value of "ALL YEARS" into a select box that is dynamically populated from a table where the value doesn't exist??

Appreciate the input!!!

[bubblenut]

You could add on another tag (for example; all_years as the value) which triggers a different query at the other end. To add this into the select you would simply append (or prepend) it to the $years_block variable; something like this.

<?php
// create SQL statement for YEARS
$years_sql = "SELECT distinctrow year FROM races where workout_type = 'Race'";
// execute SQL query and get result
$years_sql_result = mysql_query($years_sql,$con)
or die("Couldn't execute query.");
// put data into ARRAY box FOR years select box
while ($rowY = mysql_fetch_array($years_sql_result))
{
$years = $rowY[year];
$years_block .= "<OPTION VALUE=\"$years\">$years</OPTION>";

}
$years_block.="<OPTION VALUES=\"all_years\">All Years</OPTION>";
echo "<Select name=yearsel>";
echo $years_block;
echo "</select>";
echo " and "; 
?>

HTH
Bubble

[ndorfnz2]

Cool this works nicely!

Adding a bit more complexity to it now though...

I want to keep the value that is selected by the user and display in the select box after Submit is pressed.

How can I accomplish this given:
<?php
// create SQL statement for YEARS
$years_sql = "SELECT distinctrow year FROM races where workout_type = 'Race'";
// execute SQL query and get result
$years_sql_result = mysql_query($years_sql,$con)
or die("Couldn't execute query.");
// put data into ARRAY box FOR years select box
while ($rowY = mysql_fetch_array($years_sql_result))
{
$years = $rowY[year];
$years_block .= "<OPTION VALUE=\"$years\">$years</OPTION>";

}
$years_block.="<OPTION VALUES=\"all_years\">All Years</OPTION>";
echo "<Select name=yearsel>";
echo $years_block;
echo "</select>";
echo " and ";

?>

Now let's say the user selects 2003 from the select box. I want to keep it upon refreshing of the page after user clicks submit...

You help me with this one and you rule!!! It's my final piece of my project!!!! Oh man!!!