STONE ! i am trying to fight with this code now? that i still have problems
maybe u can help to figure it out like the other to know where it is the problem!!


i want to sort alphabetically select field values that take data from a table column so when a add a new record this do not appears in the select list in the bottom but in the alphabetically order it should be!

i am using this but i do not know what i am doing worg

Global : bselect_ord

sub {
my $table = shift;
$DB->table($table)->select_options("ORDER BY phonec_name");
my $results = $DB->table($table)->select()->fetchall_hashref;
return { loop_select => $results };
}


Html

<%bselect_ord('t_phonec')%>
<select name='phonec_name'>
<option value=''>--</option>
<%loop loop_select%>
<option value='<%phonec_name%>'><%phonec_name%> </option>
<%endloop%>
KevinW ANDRE
webmaster@cyberbrickell.com