Date: 10/05/06 (MySQL Communtiy)    Keywords: no keywords

Is it possible to insert data into a row above/before the previous point?

Example:

            If  “Y” is already in the DB
            Can I insert “Z” above the “Y” row so that it appears (when viewed):

Z
Y

I don’t even know how I’d look this up.

I’ve been storing Dates and Times (and what the user did) in plain text (Oct-05-2006) in separate columns.

User logs in  ---  Information stored
User downloads a file ---- Information stored

Without having to rewrite all the scripts that look at this data, I was simply hoping to write it in a different order---one more preferable for viewing.

After all the great help  (Really—Thanks!) I can see that I just need to store time/date properly and change the ORDER by which I bring things up on the screen.

Thanks again!

Source: http://community.livejournal.com/mysql/104531.html