List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:July 2 2001 1:21pm
Subject:Re: ORDER BY DESC, missing rows
View as plain text  
I doubt this is a MySQL problem.  You are probly not indexing properly, 
and you are always missing one or two entries, but only notice it with 
the DESC option.

Pat Malone wrote:

> I have a problem with a bulletin board type system.  When a new
> message is posted the script redirects back to the page that displays
> the messages.  If I do a simple query i.e.
> SELECT * FROM messages WHERE subject='$subject'ORDER BY ID
> Then all relevant messages are displayed including the one just added.
> If I want to display the last message first
> SELECT * FROM messages WHERE subject='$subject'ORDER BY ID DESC
> Then the last couple of messages are always missing!

Gerald L. Clark

ORDER BY DESC, missing rowsPat Malone30 Jun
  • Re: ORDER BY DESC, missing rowsGerald Clark2 Jul