Re: [PHP] invert

2005-08-26 Thread Richard Lynch
On Thu, August 25, 2005 2:38 pm, George B wrote: >> mysql_query('SELECT * FROM table ORDER BY increment_field DESC'); Remember when I told you that you should consistently use: mysql_query(...) or die(mysql_error()); so that MySQL would TELL you what the error was? I meant it when I said that.

Re: [PHP] invert

2005-08-25 Thread Jordan Miller
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 wri

Re: [PHP] invert

2005-08-25 Thread George B
Ł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

Re: [PHP] invert

2005-08-25 Thread Łukasz 'nostra' Wojciechowski
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

Re: [PHP] invert

2005-08-25 Thread George B
Jordan Miller wrote: if you are using mysql, just put the "DESC" (descending) directive at the end of your sql statement (default is no "DESC" directive, meaning ascending). most recent records will be returned first. Jordan On Aug 25, 2005, at 2:21 PM, George B wrote: I have written a sh

RE: [PHP] invert

2005-08-25 Thread Jay Blanchard
[snip] 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 th

Re: [PHP] invert

2005-08-25 Thread Jordan Miller
if you are using mysql, just put the "DESC" (descending) directive at the end of your sql statement (default is no "DESC" directive, meaning ascending). most recent records will be returned first. Jordan On Aug 25, 2005, at 2:21 PM, George B wrote: I have written a shoutbox, and it works g