Php mysql

[gamerzbm]

Hey guys whats the best way to store Time and date into mysql im trying to store time and date for my bidding system so i can calculate time left on an item so does anyone know

[MentaL]

[jM2.me]

timestamp
http://www.php.net/time

[gamerzbm]

thanks what about the MYSQL column ? do i use timestamp datetime int(11) would u know i already have the table but the should the column bee

[jM2.me]

In MySQL I always do following: 'timestamp' varchar(64)

[alphaest]

In MySQL I always do following: 'timestamp' varchar(64)

varchar for a time stamp? sounds like too loose restrictions for me

Im usually using int, it isnt the best to see the dates from phpMyAdmin but its the easiest to work with in php

[gamerzbm]

so ALTER TABLE `mytabe` ADD `time` int(11)NOT NULL ;

??? thats how?

[jM2.me]

varchar for a time stamp? sounds like too loose restrictions for me

oups. i was meant to write int(11) but dono why i wrote varchar(64)
poor me