Hi, Can you just
SELECT x, y, z FROM table WHERE <condition> ORDER BY timestamp_column DESC; ? -Dan On Tue, 17 Dec 2002, Mpu Gondrong wrote: > Hello mysql, > > I am currently building news portal with php and mysql, and quite > surprised knowing mysql doesn't support descending index. Why ? I > think this feature is really needed. For example I want to show the > latest news (from last updates, not always everyday). With ascending > index, mysql doesn't use it. > > My current trick is crawling back (ie 1 month) and forward (if any in > that month), but this is really annoying. Any plan / trick for this ? > TIA. > > Tertanda, > Oguds [36856104] > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > -- Regards, Dan Goodes PlanetMirror Admin http://planetmirror.com/ [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php