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
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php