Help!
I'm trying to order posts such that the most recent post or reply floats to the top. It doesn't work but it at least groups posts by date - see vwsucks.com for what I mean! Someone just posted and it's number 11 on the list! -When someone posts, I set last_reply to the current date. -When someone replies, I update the original post with the new last_reply date. -It's an access database. -last_reply is date/time field Original Post: INSERT INTO post (ip,name,postdate,title,info,email,showemail,reply_id,last_reply) Display by date: SELECT * FROM post WHERE reply_id=0 ORDER BY last_reply desc Any help is greatly appreciated! --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
