I would like to display "View All" in alphabetic order according to my first field, which is "City".

If the other searches were also displayed alphabetically that would be OK, but this "View All" (based on my first field) would really clean things up.

Thanks much, in advance. Catster

When you say that "City" is your first field, do you mean that it's field number 0? If so, you can edit sub html_footer in html.pl to do what you want.

print qq!| <A HREF="$db_script_link_url&sb=0&view_records=1&$db_key=*">
List All</A> ! if ($per_view);

Add the stuff in bold above. If "City" is field number 1, use

&sb=1

(I think you should begin to see a pattern here. )

Just use the field number that you want it to sort by. You can set the sort by field on the search page (for other searches) by the select field on the page.

If you don't specify a field to sort by, the script just lists records in the order in which they were added.


------------------
JPD