I would most definitely recommend pulling them from a DB table
rather than hard coding these into a page.  Here is a code snippet that I
use to do this on one of my pages:

mysql_select_db($Prod, $Prod);
$query_systems = "SELECT Name FROM systems ORDER BY Name ASC";
$systems = mysql_query($query_systems, $Prod) or die(mysql_error());
# $row_systems = mysql_fetch_assoc($systems);
$totalRows_systems = mysql_num_rows($systems);
$sys_list = "<select size=\"1\" name=\"system\">\n";
$sys_list .= "<option>System Name</option>\n";
$sys_list .= "<option>-----------</option>\n";
while($name = mysql_fetch_row($systems)) {
  $sys_list .= "<option>$name[0]</option>\n";
$sys_list .= "</select>\n";

<<  snip...HTML portion below >>

<td width="124" valign="top"><div align="right">System Name:</div></td>
      <td colspan="2" valign="top"> 

<< snip >>

        I also do this with Enum field selections using the following
function that someone passed on to me:

function getEnumOptions($table, $field) {
   global $finalResult;
   $finalResult = array();

   if (strlen(trim($table)) < 1) return false;
   $query  = "show columns from $table";
   $result = mysql_query($query);
   while ($row = mysql_fetch_array($result)){
        if ($field != $row["Field"]) continue;
        //check if enum type
        if (ereg('enum.(.*).', $row['Type'], $match)) {
            $opts = explode(',', $match[1]);
            foreach ($opts as $item)
                $finalResult[] = substr($item, 1, strlen($item)-2);
                return false;
   return $finalResult;

        You can then use code similar to the first example to create your
dropdown list from Enum field values.  I hope this helps.

-----Original Message-----
From: Roland Perez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 11:03 AM
Subject: [PHP-DB] Code for drop down lists

I am a novice to PHP and am trying toget a survey with drop down lists.
I am stuck as to if I should connect to the DB (MySQL DB) to get the
values from a table or do I imbed them in the php file?

Thanks for any help in advance.
Roland Perez

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to