drop down list

[torvald_helmer]

how to create a drop down list with data from a database?

[trq]

Simple example.

 

<?php

  // connect
  $sql = "SELECT data FROM tbl";
  if ($result = mysql_query($sql)) {
    if (mysql_num_rows($result)) {
      echo "<select>";
      while($row = mysql_fetch_assoc($result)) {
        echo "<option value='{$row['data']}'>{$row['data']}</option>";
      }
      echo "</select>";
    }
  }

?>

[pocobueno1388]

<?php

//Select the data from the DB
$sql = mysql_query("SELECT col1, col2 FROM tbl WHERE condition");

//Start dropdown
echo '<select name="s_name">';

//Populate the drop down with results from the DB
while ($row=mysql_fetch_assoc($sql)){
   echo "<option>" . $row['col'] . "</option>";
}

//end drop down
echo '</select>';
      
?>

 

I can see someone posted while I was, but I might as well post mine too since I spent the time typing it, haha.

[torvald_helmer]

Thanks guys!!

[trq]

<?php

//Select the data from the DB
$sql = mysql_query("SELECT col1, col2 FROM tbl WHERE condition");

//Start dropdown
echo '<select name="s_name">';

//Populate the drop down with results from the DB
while ($row=mysql_fetch_assoc($sql)){
   echo "<option>" . $row['col'] . "</option>";
}

//end drop down
echo '</select>';
      
?>

 

I can see someone posted while I was, but I might as well post mine too since I spent the time typing it, haha.

 

Sorry, but thats a pretty bad example. Absolutely no error handling.

[pocobueno1388]

I understand I didn't do any error checking, I was showing her how to populate a drop down list as they asked, not teach them how to error handle.

[eddedwards]

if u get your data into an array this simple example might be usefull. im not too hot on db stuff though.

 

<?php

$test_array = array();

$test_array[0] = "Yes";

$test_array[1] = "No";

$test_array[2] = "Maybee";

 

echo "<select name=\"test_select\" >\n";

foreach ($test_array as $option)

{

if ( isset($option) && $option == "Yes")

{

echo "<option value=\"" . $option .  "\" selected>" . $option . "</option>\n";

} elseif ( isset($option) ) {

echo "<option value=\"" . $option .  "\">" . $option . "</option>\n";

}

}

echo "</select>";

?>