Patael,
This is a help forum, not a cut-and-paste code gallery. It exists to give us an additional method of obtaining help with those annoying problems we just can't seem to solve on our own. It does not exist to be a place where you have other people write your code for you. You'll need to figure out date manipulation at some time, why put out to tomorrow what you can learn today?
Now, for the help.......
The most flexible way to store dates/times in any database is as a Unix timestamp. Storing as a timestamp instead of in a pre-formated string (ie. D/M/Y) allows you to easily change the display format in your code at runtime. It also means if you need to change the display format to somwthing else (ie. YYYY-MM-DD), you don't need to change all the data in the db. Much more friendly. Don't use the MySQL TIMESTAMP datatype, it's not a Unix timestamp. Rather, use an INTEGER type and the following statement to insert new dates:
$sql = "INSERT INTO table (time) VALUES (".mktime().")";
Then, read the section of the manual on the date() function to discover all the different chars you combine into a string to create the format template. Feed the stored timestamps into the function to format as you so desire. Example:
echo date("d/m/Y", $timestamp);
where $timestamp is a Unix timestamp retrieved from the database.
-geoff
