function set_and_enum_values( $table , $field ){
	$query = "SHOW COLUMNS FROM `$table` LIKE '$field'";
	$result = mysql_query( $query ) or die( 'Error getting Enum/Set field ' . mysql_error() );
	$row = mysql_fetch_array($result);
	if(stripos(".".$row[1],"enum(") > 0) $row[1]=str_replace("enum('","",$row[1]);
		else $row[1]=str_replace("set('","",$row[1]);
	$row[1]=str_replace("','","\n",$row[1]);
	$row[1]=str_replace("')","",$row[1]);
	$ar = split("\n",$row[1]);
	for ($i=0;$i<count($ar);$i++) $arOut[str_replace("''","'",$ar[$i])]=str_replace("''","'",$ar[$i]);
	return $arOut ;
}

function set_and_enum_values( $table , $field ){
		$query = "SHOW COLUMNS FROM `$table` LIKE '$field'";
		$result = mysql_query( $query ) or die( 'error getting enum field ' . mysql_error() );
		$row = mysql_fetch_array($result);
		$row[1]=str_replace("set('","",$row[1]);
		$row[1]=str_replace("','","\n",$row[1]);
		$row[1]=str_replace("')","",$row[1]);
		$ar = split("\n",$row[1]);
		for ($i=0;$i<count($ar);$i++) $arOut[$ar[$i]]=$ar[$i];
		return $arOut ;
}

function set_enum_select( $table , $field ){
		$query = "SHOW COLUMNS FROM `$table` LIKE '$field'";
		$result = mysql_query( $query ) or die( 'error getting enum field ' . mysql_error() );
		$row = mysql_fetch_array($result);
		$row[1]=str_replace("set('","",$row[1]);
		$row[1]=str_replace("','","\n",$row[1]);
		$row[1]=str_replace("')","",$row[1]);
		$ar = split("\n",$row[1]);
		for ($i=0;$i<count($ar);$i++) $arOut[$ar[$i]]=$ar[$i];
		return $arOut ;
}

http://www.barattalo.it/2010/01/19/php-to-get-enum-set-values-from-mysql-field/

mysql php get enum values

mysql, php

SQL