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