function get_enum($table,$clname){ $Query="SHOW COLUMNS FROM `$table` LIKE '$clname'"; $result = $this->db->query($Query) or die("Get Enum value Query"); if($result){ $row = mysql_fetch_array( $result , MYSQL_NUM ); $regex = "/'(.*?)'/"; preg_match_all( $regex , $row[1], $enum_array ); $enum_fields = $enum_array[1]; return $enum_fields; } return false; }
Html, JAVA,DOTNET,Javascript, PHP, and JQuery Scripts and its issues with solutions
Showing posts with label Enum. Show all posts
Showing posts with label Enum. Show all posts
Tuesday, 24 June 2014
How to get Enum Values in Mysql?
Subscribe to:
Posts (Atom)