I'm trying to create a sort function that permits me to sort this my Status field by status as opposed to alpha. I need a sorting ruitine that will change:
the ordering to Leader = 1; Officer = 2; Member = 3. Keep in mind I'm pretty new to cgi but somewhat knowledgeable on html.
My .cfg file fields for this field look like this:
%db_select_fields = (
'title' => 'Leader,Officer,Member',
);
my record layout for this field for viewing in .pl is:
<td width="80"$fsmall><br><a href="$db_script_link_url&&view_records=1&key=*&sb=1&so=ascend">Title</a></b></font></td>
I need to figure out two things:
(1) What new function/programming needs to be added to sort via number and
(2) Where that new function/programming needs to be added.
Any help would be greatly appreciated. FYI, I read the sorting stuff on the FAQ by DBJeni but I couldn't find anything on point with the exception of a post discussing <Input type blahblahblah> but it ended abruptly...
the ordering to Leader = 1; Officer = 2; Member = 3. Keep in mind I'm pretty new to cgi but somewhat knowledgeable on html.
My .cfg file fields for this field look like this:
%db_select_fields = (
'title' => 'Leader,Officer,Member',
);
my record layout for this field for viewing in .pl is:
<td width="80"$fsmall><br><a href="$db_script_link_url&&view_records=1&key=*&sb=1&so=ascend">Title</a></b></font></td>
I need to figure out two things:
(1) What new function/programming needs to be added to sort via number and
(2) Where that new function/programming needs to be added.
Any help would be greatly appreciated. FYI, I read the sorting stuff on the FAQ by DBJeni but I couldn't find anything on point with the exception of a post discussing <Input type blahblahblah> but it ended abruptly...