RE:function() for mysql-enum-field-values-to-array
| From: | Dennis Gearon | Date: | Thu, 15 Mar 2001 18:23:28 +0000 |
| Subject: | RE:function() for mysql-enum-field-values-to-array | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-44092@lists.php.net to get a copy of this message | ||
I also have thought about improving that function to make the default
first,or a switch anyway.
>function mysql_fetch_enums( $link, $table_name, $field_name ){
> $mysql_datatype_field = 1;
> if (!$result = mysql_query ("SHOW COLUMNS FROM $table_name LIKE
>'$field_name'", $link ) ){
> $output=0;
> } else {
> $mysql_column_data = mysql_fetch_row( $result );
> if ( !$enum_data= $mysql_column_data[$mysql_datatype_field] ){
> $output=0;
> } else if ( !$buffer_array=explode("'", $enum_data) ){
> $output = 0;
> } else {
> $i = 0;
> reset ($buffer_array);
> while (list(, $value) = each ($buffer_array)) {
> if( $i % 2 ) $output[] = $value;
> ++$i;
> }
> }
> }
> return $output;
>}