Re: ORDER BY DESC, missing rows

2001-07-02 Thread Gerald Clark
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

ORDER BY DESC, missing rows

2001-06-30 Thread Pat Malone
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