Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [kevinws] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW?

Quote Reply
Re: [kevinws] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW? In reply to
SmileSTONE ! 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_ordPirate

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
Subject Author Views Date
Thread PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW? kevinws 4104 Feb 19, 2004, 1:15 PM
Thread Re: [kevinws] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW?
ltillner 3986 Feb 19, 2004, 3:42 PM
Thread Re: [ltillner] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW?
kevinws 3971 Feb 20, 2004, 6:56 AM
Thread Re: [kevinws] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW?
604 3954 Feb 20, 2004, 9:52 AM
Thread Re: [TheStone] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW?
kevinws 3946 Feb 20, 2004, 10:24 AM
Thread Re: [kevinws] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW?
kevinws 3968 Feb 20, 2004, 10:57 AM
Thread Re: [kevinws] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW?
kevinws 3964 Feb 20, 2004, 11:03 AM
Thread Re: [kevinws] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW?
604 3986 Feb 20, 2004, 4:26 PM
Post Re: [TheStone] PLEASE, SELECT FIELD LIST SHOWing NON REPEATED DATA HOW?
qango 3916 Feb 26, 2004, 7:06 AM