in reply to DBI returning mysql columns in strange order.
If you get them back in a HASHREF then you can deal with them in whatever order you like. You cannot rely on any order when you are using HASHes. Nor should you!
jdtoronto