Hello...
please tell me if this is feasable...
I have two tables:
timetable - the database which contains information to be displayed (yes it's a time table ; > )
sorttable - the database which contains sort order. It has 3 fields... id, sortorder and fieldname...
where the fields from timetable are listed inside the fieldname field. so the numbers match...
Is it at all possible to use a query such as:
query "sorttable - select * from sorttable where route = '$route' and table = '$table' order by sortorder asc";
and then use that query to sort the dynamically displayed table (timetable)?