Re: Dealing with ENUM fields

Hi! there is a much shorter way to do this (which works with ENUM and SET): $qry = 'SHOW COLUMNS FROM gruzilla_content LIKE "module"'; $res = mysql_query($qry); if(mysql_num_rows($res)>0) { $row = mysql_fetch_row($res); $pattern = "#(enum|set)\('(.+?)'\)#i"; $replace = '\\2'; $row[1] = preg_replace($pattern, $replace, $row[1]); $options = explode("','", $row[1]); } $options now contains every value of the enum. I think there is also a possibility to do this within a query - but currently i do not find the script on my HD.... :) - so this is a nice workaround! .ma Lisi <lists@shemeshdirectory.co.il> wrote@02.06.2003 11:53 Uhr: > 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: [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 >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php > Matthias Steinböck Email: grillen@abendstille.at Web: http://www.abendstille.at Frühabendliches Webdesign. ------------------------------------------ Im Übrigen sind wir der Meinung, dass unsere Gesellschaft Gabel-diskriminierend Löffel verwendet. Alle Macht den Gabeln!