[GLLUG] PHP/MySQL Dev question (again)

Mike Szumlinski szumlins@pilot.msu.edu
Sat, 16 Nov 2002 15:42:47 -0500

Okay, here is what I'm tryin' to do...probably simple...

I have a table that users update that has a timestamp (dateadded) 
within it.  That used to suffice when the users could only ADD items, 
but now that they can modify as well, every time the item is modified 
the timestamp grabs the new time.  Since my list is ordered by date, 
this throws things off...so I need to figure out a way to add a 
modified date (which would be the timestamp) to the table as well as 
the dateadded field (which is not null and is unchangeable).

I was using the dateadded timestamp as a unique ID (probably not the 
greatest idea, but since I don't think 2 people will post at the exact 
same time down to the second on the site, I'm not that worried).  But 
now that the dateadded timestamp changes when the data in the table is 
modified, it just screws everything up.  Any ideas on how to do this 
would be much appreciated.