To add the current date to a database:

First, you need ot create the database and put a field in it like:

Then when you add that field to the db use the CURDATE( ) function in your querry string, like this:

$query = "INSERT INTO properties (type, price, Date_Added) VALUES ('$type', '$price', CurDate())" ;

Inside the DB, the value of the Date_Added filed will look something like this:   2008-02-22

NOTE: Inside the query string, CurDate is case insensitive AND it is not surrounded by tic ' ' marks, nor does it have the $ sign for a variable.