Re: invert
| From: | George B | Date: | Thu, 25 Aug 2005 19:38:00 +0000 |
| Subject: | Re: invert | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-221381@lists.php.net to get a copy of this message | ||
Łukasz 'nostra' Wojciechowski wrote:
W odpowiedzi na maila (21:21 - 25 sierpnia 2005):Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in myfile name on line 30 and on line 30 it says while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { I dont understand what is problem here...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 If I do that... then i get this error