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!



-- 
Best regards,
Pat
[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

Reply via email to