[jozin]

Hi,

I'm doing a simple program to store birthdays. I'm trying to save a DATE in my database but the saved data in my BIRTHDAY column is:

0000-00-00 00:00:00

my code is:

$SQL="INSERT INTO employee (employeeID, employeename, Address, Birthday) VALUES ('".$empID."','".$empname."','".$address."', '".$bday."')";

I simply chose the Date/Time format in my database.

I tried to apply $bday = date($bday, "m/d/y") but it didn't work.

Please show me what is wrong with my code.

Thanks for the help and more power.

jozin

[<?Wille?>]

you could do the column DATE type and store the bdate in yyyy-mm-dd format.. other option that i think is alot better is that you make the column bigint format and store the the birthday as a unix timestamp (seconds since 1.1.1970).. that way its alot easyer to format the date as the user wants it (if you have register'd users)

[moronovich]

hello jozin,
first, please take a look to datetime type in mysql:
http://dev.mysql.com/doc/mysql/en/DATETIME.html

after that, i think you'll discover the way to insert the date to your mysql database.

good luck!!

[4n7hr4x]

the SQL,
table is what ever you want, i will use the exaple date for the column:

CREATE TABLE w/e (**** **** blah blah, date DATETIME);
you know how to do that I assume, you could also use TIMESTAMP, but i prefer datetime, you can look both up on mysql.com see which one you prefer.
then when you are entering into the database, you use NOW() for the date insert, ex:

INSERT INTO w/e (date) VALUES (NOW());

never put NOW() into ' '

hope that this helps

[jozin]

Hi Guys,

Thanks a lot for your replies. I've learned a lot about date format and PHP especially the DATETIME.html from moronovich. I sure can use these help in my future projects.

Thanks again and more power,

jozin