Posted by �ukasz 'nostra' Wojciechowski on 08/25/05 22:32

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

• Next in forum: Re: [PHP] invert
• Prev in forum: Re: [PHP] invert
• Thread view: Re: [PHP] invert

[Reply to this message]