Right, I am developing a ticket system. I have two tables:
And I display all tickets bt executing an SQL query that selects tickets in order of datetime - note this is the submited datetime. What i would like it to display a list of tickets ordered by the last message datetime - much as threads are ordered in this forum.
Can I use SQL to do this or will I need to script this?