help with date

[esbsolutions]

Can someone please help me get the current date into my database?

I have the following in my php:

$LeadDatePosted = getdate('Y m d');

This posts 0000-00-00 to my mysql database for some reason. For the LeadDatePosted field I have the type set to DATE. How can I make this work? Thanks in advance!

[JoeBrewer]

Try this:

$LeadDatePosted = date('Y m d');

Joe

[esbsolutions]

same result..........any other suggestions?

[bubblenut]

If your table is set to date then you should use MySQL's date functions. Have a look here and here for more info.
HTH
Bubble