[SOLVED] select box+query from database

[drummer101]

So I've got a date select box, what I'd like to do is query the database for the date, and have the date in the database show up in the date select box (<option selected="selected">) but I can't quite wrap my brain around how to do it, and keep them in numerical order.

 

// Month Select Box

 

echo "<select>";

 

for($m=1; $m<=12; $m=$m+1){

 

echo "<option value=\"$m\" name=\"month\">$m</option>";

 

}

 

echo "</select>";

 

 

 

// Day Select Box

 

echo "<select>";

 

for($d=1; $d<=31; $d=$d+1){

 

echo "<option value=\"$d\" name=\"day\">$d</option>";

 

}

 

echo "</select>";

 

 

 

 

 

// Year Select Box

 

echo "<select>";

 

for($y=2008; $y>=2008; $y=$y-1){

 

echo "<option value=\"$y\" name=\"year\">$y</option>";

 

}

[/php

[.josh]

Assuming that you retrieved your date from the database and split it up into vars...

 

echo "<select>";

   for($m=1; $m<=12; $m=$m+1){

      $selected = ($m == $month)? 'selected' : '';
      echo "<option value=\"$m\" name=\"month\" $selected>$m</option>";

   }

   echo "</select>";

[drummer101]

Assuming that you retrieved your date from the database and split it up into vars...

 

echo "<select>";

   for($m=1; $m<=12; $m=$m+1){

      $selected = ($m == $month)? 'selected' : '';
      echo "<option value=\"$m\" name=\"month\" $selected>$m</option>";

   }

   echo "</select>";

Would that not return ALL values as selected?

 

The code I posted above builds the select box and populates it with values.

[drummer101]

Oh right, I get it.