Posted by Jordan Miller on 08/25/05 22:42

you need to provide more information. we cannot tell what you are
doing. you should:
**PASTE THE RELEVANT SECTION OF YOUR CODE IN YOUR EMAIL**


On Aug 25, 2005, at 2:38 PM, George B wrote:


> Łukasz 'nostra' Wojciechowski wrote:
>
>
>> 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
>>
>>
> If I do that... then i get this error
> 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...
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>
>

[Back to original message]