Codezwiz >> Forums >> General PHP Nuke Help >> MySQL: Query to return enumerated types?

Folks,

How might I query & display the enumerated types located in a MySQL db table so I can display them in pull-down menu in a phpnuke block?

The field is defined as:

type | enum('Published Article', 'Newsletter', 'Whitepaper') | default('Published Article')

Without examining each and every article stored in the database, is there a way to pull out the enumerations so I can display them in a drop-down?

The alternative is to create an ancillary table indexed by ID containing the text label. Now that I think about it, is that a better way to handle it because it offers easier internationalization?

Curtis

Whups. Found the answer

$result_pubs = $db->sql_query("SHOW COLUMNS FROM ".$prefix."_pcgpublications LIKE 'type'");
// code from MySQL Manual http://dev.mysql.com/doc/mysql/en/ENUM.html
if($db->sql_numrows($result_pubs)>0){
$row=$db->sql_fetchrow($result_pubs);
$pub_list=explode("','",preg_replace("/(enum|set)$'(.+?)'$/","\\2",$row[1]));