Hi Everyone,

I'm trying to figure out how to properly configure my mysql database to store numbers as a timestamp. I don't believe this is the correct way to do so. I tried changing the TYPE to VARCHAR but I get a mysql error. The below URL is where I want my user to input information.

Column
TYPE | timestamp
Default | CURRENT_TIMESTAMP
Collation
Attributes | ON UPDATE CURRENT_TIMESTAM
Null
Auto_Increment
Comments

http://whatsmyowncarworth.com/auto-m.../math/math.php

>>>>>>>>>>

This is what I'm trying to do.

At the below URL their are two users. They each have a favorite number.

http://www.whatsmyowncarworth.com/au...ember-info.php
hockeyman = 2
coolguy = 3

If hockeyman changes his number to 8
and
coolguy changes his number is 12

Using a timestamp what's the best way to store the old numbers of 2/3? while keeping the new numbers of 8/12.

Thanks everyone!