RE: [PHP-DB] Populating a dropdown list with ENUM values... From: NIPP, SCOTT V (SBCSI) (sn4265 <email protected>)
Date: 06/26/02

        Thanks to everyone who responded. I have found a function that
fills the role perfectly.

-----Original Message-----
From: Russ [mailto:russ <email protected>]
Sent: Wednesday, June 26, 2002 7:47 PM
To: NIPP, SCOTT V (SBCSI); php-db <email protected>
Subject: RE: [PHP-DB] Populating a dropdown list with ENUM values...

G'day Scott:

I wrote this function to do just what you're atfer:
You may need to mess with it for you're own needs - but go for your
life!

//----function: "enum_select()" - automatically generate an HTML select
menu from a MySQL ENUM field
//----1). takes a table name: '$table'
//----2). a name for the menu '$name'
//----3). a CSS class
function enum_select($table,$name,$class) {
         $sql = "SHOW COLUMNS FROM $table";
         $result = mysql_query($sql);
         $select = "<select name=\"$name\" class=\"$class\">\n\t";
         while($myrow = mysql_fetch_row($result)){
                  $enum_field = substr($myrow[1],0,4);
                  if($enum_field == "enum"){
                           global $enum_field;
                           $enums = substr($myrow[1],5,-1);
                           $enums = ereg_replace("'","",$enums);
                           $enums = explode(",",$enums);
                           foreach($enums as $val) {
                                        $select .= "<option
value=\"$val\">$val</option>\n\t";
                                        }//----end foreach
                                }//----end if
                        }//----end while
                $select .= "\r</select>";
                return $select;
}//----end function

All the best.
Russ

-----Original Message-----
From: NIPP, SCOTT V (SBCSI) [mailto:sn4265 <email protected>]
Sent: Thursday, June 27, 2002 3:38 AM
To: 'php-db <email protected>'
Subject: [PHP-DB] Populating a dropdown list with ENUM values...

        I am working on an application that has several different fields
that are populated dropdown lists. In every case, this data is simply
data
from a MySQL table column and works great. I have run into a new
difficulty
though... One field that I am wanting to populate in a dropdown list is
an
ENUM field. I am trying to figure out how to do this. I have seen a
couple
ideas in the newsgroups, but most are pretty complex and about a year or
so
old. I am hoping for a simpler solution that may have been developed
since
these posts. Thanks in advance.

Scott Nipp
Phone: (214) 858-1289
E-mail: sn4265 <email protected>
Web: http:\\ldsa.sbcld.sbc.com 

-- 
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