Ok I'm not an expert on php or databases or anything like that, but I'm working on the highscore recording for my game and I've got everything working except for the goddamn date.

I can save the date as a string (varchar) in the mySQL table, but I really want to save it as a type (date) so I can query it easier.

$date = getdate();

doesn't seem to work when I try insert $date into the table. Is there some silly format I have to use to get it into the table?

_________________
Attack of the Meeplings - Free 2D Arcade Shooter
Caverns of Underkeep - Free Browser Based Roguelike

Yup, stupid formating thing

$today = getDate();
$today = date("Y-m-d");

_________________
Attack of the Meeplings - Free 2D Arcade Shooter
Caverns of Underkeep - Free Browser Based Roguelike

the timestamp field can have it's date set automatically using NOW(), no code needed.

_________________
Serious game developer

http://www.persistentrealities.com
http://www.persistentrealities.com/vbfibre
http://www.ambiances.nl