Archive for November 23rd, 2005

Retrieve valid entries for a MySQL ENUM/SET column

Here's a handy little PHP function I threw together to retrieve valid entries for a MySQL ENUM/SET column, handy for generating dynamic radio group/checkbox/multiple select HTML elements:

PLAIN TEXT
PHP:
  1. // grab possible SET/ENUM values and return an array
  2. function getPossibleValues($table,$field){
  3.  
  4.     $query = "SHOW COLUMNS FROM `$table` LIKE '$field'";
  5.     $result = mysql_query($query);
  6.    
  7.     if(mysql_num_rows($result)>0){
  8.         list(,$fields) = mysql_fetch_row($result);
  9.         $options = explode("','",preg_replace("/(enum|set)('(.+?)')/","\2",$fields));
  10.         return $options;
  11.     } else {
  12.         return array();
  13.         return false;
  14.     }
  15.  
  16. }

4 comments November 23rd, 2005

Calendar

November 2005
M T W T F S S
    Dec »
 123456
78910111213
14151617181920
21222324252627
282930  

Posts by Month

Posts by Category