Hi Gareth, grab yourself a copy of openforums (fbopenforums.sourceforge.net) - it's a coldfusion fusebox forum I wrote, and it sorts the threadlist by last post, and actually has mysql queries in there as well, so you can see how it's being done - you want to look in the queries directory for something like qry_getThreadList_mys.cfm
cheers, Toby Thursday, September 18, 2003, 9:30:22 AM, you wrote: G> I am writing a forum, in one table I have my topics and the replies to those G> topics. G> I wish to be able to sort by the 'last post' which is the 'added' field in G> my topics table. G> This at first seems simple. But where I wish to sort it is where the topic G> headers are listed. Basically I need to join the 'topics' table to itself, G> which I have done but then I need to ask the join to return the entry with G> the latest date (maybe some sort of order?), at the moment it returns the G> first entry that it can find, so if there is only one reply to a topic it G> works perfectly, but this is a forum so there is no chance of that G> happening. G> Hopefully someone can help me out. G> Cheers G> Gareth Edwards. G> --- G> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] G> To unsubscribe send a blank email to [EMAIL PROTECTED] G> MX Downunder AsiaPac DevCon - http://mxdu.com/ -------------------------------- Life is Poetry, write it in your own words -------------------------------- Toby Tremayne Cold Fusion Developer Code Poet and Zen Master of the Heavy Sleep Virtual Tours +61 416 048 090 ICQ: 13107913 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
