step 1:
I would set off a query to shoot all the modification dates to be equal to the creation
dates when modification date == 0000-00-00 for the current records in the database.
step 2:
now the database does not have 0000 modification date at all.
step 3:
for future inserts set the modification date to be equal to creation date ( isnt that
the case if we look at it logically: 'the article was modified when created' )
step 4:
if we modify an article we change the modification date but creation date is untouched.
step 5:
if an article was not modified at all, then its creation date would be equal to
modification date.
sort on whatever order you wish: I would take the order to be
ORDER BY Modification_Date, Creation_Date
as the latest articels would show up at the top of the query.
nilesh :-)
