Hi there, I need help in viewing the "Last Post" topic on top of other topics(like in forums)? (could someone show me a sample how sql must look like?)
TIA
sort the results by date in reverse order:
SELECT * FROM posts ORDER BY date DESC
Originally posted by devinemke sort the results by date in reverse order: SELECT * FROM posts ORDER BY date DESC [/B]
Originally posted by devinemke sort the results by date in reverse order:
[/B]
thanks devinemke, I've used timestamp and sorted that out using Desc... working just fine.. 🙂
