I just wondered how to save the time of posts or stuff like that with PHP/MySQL.

I played around with some of PHP's time functions, but I could not convert any return value to MySQL DATE...How to do this? Or is DATE wrong for this task?

I really don't know, cause I'm quite new to PHP/MySQL. [addsig]

best way is to use mysql field type called timestamp or something like that with len 14. then time is stored like this "yyyymmddhhmmss" without a help of your script.

btw, there is a data type called "date" in PHP too....
[addsig]

Thank you so far guys! [addsig]

For the current date in php I just do:
$Whatever=date("Y-m-d");
If you want to check that this is correct just add:echo $Whatever; [addsig]

http://www.php.net/manual/en/function.date.php
Here you will find everything
[addsig]

The problem is some months old now...and as you might assume, I already found the solution

Anyway, thank you guys! [addsig]

hehe, but it will maybe help somebody else later
[addsig]

ok for a virtual pet/monster site i want to create (dont moan, i know theres 1000's) i want a standard time for the site that is the same in all counties, should i use the server time or is there another way, in both cases how?

Well there are many options for date and time in both PHP and MySQL. Someone above suggested that you use a timestamp so it is automatic, this is fine, as long as you never update a field in that row, because timestamps are update upon edit.

In php check out the date() function.

In MySQL check out the date_format function.

I suggest you use a DATETIME field, and when inserting data into a row, simple add the MySQL function NOW() to add the current date and time.

I hope this helps you, if not tell me and I will try to give more help