alex.. i was thinking about something i mentioned like when Links was 1.1b1.. it was something that moved around the fields in the MySQL database for "cosmetic" reasons.

I just now thought of something else that could probably be more easily done (instead of going through a whole database rehaul). In the edit table definition section or perhaps another page you can just have another field number in the hash array and when you print out the form in build_html_record_form or whatever you just sort by that field..

better than reading the data.. putting it in memory.. dropping the table.. creating a new table and then pasting it back together..

the reason again why i would like this is cause when i add a IMPORTANT new field.. i don't like having it all the way at the bottom on the page..

i might go into this myself next tuesday when i finish a science project i need to do by tuesday..

also.. the first field in the hash arrays in the .def files.. does it represent the field position? unlike Links 2.0 it starts from 1.. so is this used for backups when it writes to the tab deliminated file? what else is it used for?

jerry