note 11071 deleted from function.mysql-field-type by jimw
| From: | jimw@php.net | Date: | Fri, 07 Dec 2001 02:18:43 +0000 |
| Subject: | note 11071 deleted from function.mysql-field-type by jimw | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-21813@lists.php.net to get a copy of this message | ||
/* function make_select_list( )
-> $link: actual db-connection-id
-> $table: name of db-table
-> $field: name of db-table-field
-> $sel: value of currently selected option (becomes "SELECTED")
<- $s constructed <option> - tag
USAGE: echo "<select size=1 name=kategorie>" . make_select_list( $link, $tabelle,
'kategorie', $kategorie ) . "</select>";
*/
function make_select_list( $link, $table, $field, $sel )
{
$s = "";
$rid = mysql_query( "SHOW COLUMNS FROM $table", $link );
$nr = mysql_num_rows( $rid );
while( list( $name, $type ) = mysql_fetch_row( $rid ))
{
if( $name == $field )
{
if( ereg( '^enum\(.*\)$', $type ))
$type = substr( $type, 6,-2 );
else if( ereg( '^set\(.*\)$', $type ))
$type = substr( $type, 5, -2);
else
return( "<option>ERROR" );
$opts = explode( "','", $type );
while( list( $k, $v ) = each( $opts ))
if( $sel == $v )
$s .= "<option value=$v selected> $v";
else
$s .= "<option value=$v> $v";
}
}
return( $s );
}