Posted By

Wardy on 12/12/08

Tagged

mysql
php

Versions (?)

Last Edited at 12/12/08 06:50am

Statistics

Viewed 833 times

Favorited by 0 user(s)

Related snippets

Retrieve valid entries for a MySQL ENUM/SET column

/ Published in: PHP

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

// grab possible SET/ENUM values and return an array
function getPossibleValues($table,$field){
	$query = "SHOW COLUMNS FROM `$table` LIKE '$field'";
	$result = mysql_query($query);
 
	if(mysql_num_rows($result)>0)
	{
		list(,$fields) = mysql_fetch_row($result);
		$options = explode("','",preg_replace("/(enum|set)('(.+?)')/","\2",$fields));
		return $options;
	}
	else
	{
		return array();
		return false;
	}
}