RE: Dealing with ENUM fields

Lisi <lists@shemeshdirectory.co.il> · Mon, 02 Jun 2003 11:53:32 +0200

I am forwarding this useful function someone once sent to the list that I 
use often.

Hope this fits your needs.

-Lisi

-----Original Message-----
From: Russ [mailto:russ@itomic.dns2go.com]
Sent: Wednesday, June 26, 2002 7:47 PM
To: NIPP, SCOTT V (SBCSI); php-db@lists.php.net
Subject: RE:  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

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