Re: invert

W odpowiedzi na maila (21:21 - 25 sierpnia 2005): > I have written a shoutbox, and it works great, but I am wondering... > When a user posts a shout it goes below the first shout. Like the > auto_increment puts the ID up higher. I need it to go about the first > shout, so like the auto_increment would invert. Someone told me this is > possible through PHP. Is that true? and if so how do you do it? mysql_query('SELECT * FROM table ORDER BY increment_field DESC'); http://dev.mysql.com/doc/mysql/en/order-by-optimization.html or get all output from DB into array and use array_reverse(); http://us2.php.net/manual/pl/function.array-reverse.php -- pozdrawiam Łukasz "nostra" Wojciechowski gg.1028640 * icq.23059512 ---------------------------------------------------------------------- Startuj z INTERIA.PL! >>> http://link.interia.pl/f186c