Listbox and mysql value

I开发者_JAVA百科 am tring to have the selected number showing on the listbox as default.

In the follow database i have

Database Name: ratings

ID ---------------- Rating

1 ---------------- 4

in my list box i have 1 - 10 i want to be able to show the Rating from the database but i want it to display it as default and when you click on the list box it got 1 - 10

$query = "SELECT Rating FROM ratings";
      $result = mysql_query($query);
      print "<SELECT name=item>";
      while ($line = mysql_fetch_array($result))
      {
      foreach ($line as $value)
      {
      print "<OPTION value='$value'";
      } 
      print ">$value</OPTION>";
      }

Thank you

You'll have to have the selected rating recorded someplace. Once you have that, it's not hard to concatenate a selected='selected' into the option.

  $Selected_ID = "4"; // You'll need this.

  $query = "SELECT Rating FROM ratings";

  $result = mysql_query($query);

  print "<SELECT name=item>";
  while ($line = mysql_fetch_array($result))
  {
  foreach ($line as $value)
  {
  // If the selected ID matches the current row, then mark it as selected.
  $Selected = ($Selected_ID == $value) ? " selected='selected'" : '';       
  print "<OPTION$Selected value='$value'";
  } 
  print ">$value</OPTION>";
  }