How can i add a timestamp that is only updated when the record is inserted, not when the record is updated. A kind of "date created" stamp
Most of the osCommerce tables have 2 fields. One called date_added and one last_modified. So on INSERT you do a NOW() on date_added and NULL on last_modified and on UPDATE a NOW() on last_modified and not touching date_added. That way you have a nice record of when it was created and when it was last edited.