$sql = "show columns from my_table";
execute
while (there are $field_names) {
     print "<input type='text' name='".$field_name."'>"
}

##</code><code>##

$public_names{$field_1} = "foo";
$public_names{$field_2} = "bar";
foreach $key (keys %public_names) {
     print "<input type='text' name='".$public_names{$key}."'>"
}

##</code><code>##


$sql = "show columns from my_table";
execute
while (there are $field_names) {
     $public_name = &encode($field_name);
     print "<input type='text' name='".$public_name."'>"
}

sub encode() {
     $scrambled =~ tr/[a-z]/[w,t,5,s,c,....,7,a]/;
     return $scrambled;
}