note 30827 deleted from function.mysql-query by didou

Note Submitter: gmalcolmSPAM@BADprofessionalcredit.com ---- An addition to the useful post on converting enums to select by claude_minette. This function returns an array for all possible values of a mysql enum field. I needed this to separate display from content. //presumes db connection function listEnum($dbtable, $fieldname){ $describe = mysql_fetch_assoc("describe $dbtable"); while ($line=mysql_fetch_assoc($describe)){ extract($line); if($Type != "enum" and $Field != $fieldname){continue;} preg_match_all("/'(\w+)'/",$Type,$choices); break; } //return only individual matches return $choices[1]; }