How do I extract/print "enum" values from column?

Volitics

Hello.

I have got a table where one of the columns has an enum column type. The column heading is "State" The enum string within the "State" column contains all of the fifty states of the union like so:

column heading: "State" enum( 'Alabama', 'Alaska', 'Arizona', 'Arkansas', ... and so forth)

My question is: Can I loop through the State column heading and extract each of the fifty enum values (or states) and output them on the page?

// example page output
Alabama
Alaska
Arizona
.....

If so, can anybody give me an idea about how it can be done?

Thanks.

Volitics

I figured out a way to do what I need. If you look at the PHP Manual about a third of the way down the page there is an example.

http://www.php.net/manual/en/function.mysql-fetch-field.php

I had to modify the example a little bit in order to get it to work. The code below is kind of a round about way of getting the results. If anybody knows of a better way I would appreciate knowing about it.

$Result = mysql_query("SHOW COLUMNS FROM table");
while($Row = mysql_fetch_object($Result)){
   if ( (ereg(('set|enum'), $Row->Type)) AND ($Row->Field == 'State') ){
   	$ColHeading[] = $Row->Type;
   }
}

foreach ($ColHeading as $Key1 => $Value1){
	 // Strip out enum(' from start of string
	$Value1 = str_replace("enum('',", "", $Value1);
	 // Strip out ) from end of string
	$Value1 = str_replace(")", "", $Value1);
	 // Turn string into an array.
	$Value1 = explode(",", $Value1);
		foreach($Value1 as $Key2 => $Value2){
		echo $Value2."<br>";
		}
			}

Thanks.

konrad

<?php
 $sql = 'SHOW COLUMNS FROM table_name LIKE "States"';
 $res = mysql_query($sql);
 $row = mysql_fetch_array($res);
 $dat1 = str_replace(array('enum(',')','\''), '', $row['Type']); 
 $values = explode(',',$dat1);  

 print_r($values);
?>