Please Help !

[Dan Anderson]

> I know this is really basic but i have a form for users to enter the

> date of an event that i would like to store in a mysql database how do i
> get the users input into the database in the right format.

Read up in the manual of mySQL, and the parts of the PHP doc on mySQL.

mySQL dates are stored YYYY-MM-DD.

-Dan

[Sean O'Reilly]

Hi,

I know this is really basic but i have a form for users to enter the
date of an event that i would like to store in a mysql database how do i
get the users input into the database in the right format.

[Anthony]

look up two functions in the online manual. strtotime() and date()
strtotime will give you a unix timestamp for just about any date possable,
date will format it the way you need. to get it into a mySQL date field,
basicaly, you do this:

date("y-m-d", strtotime($_POST['date']))

where $_POST['date'] is whatever variable you used.

- Anthony


"Sean O'Reilly" <s.oreilly@sussexcoast.co.uk> wrote in message
news:1057675256.17432.55.camel@sean.linnovations.c o.uk...

> Hi,
>
> I know this is really basic but i have a form for users to enter the
> date of an event that i would like to store in a mysql database how do i
> get the users input into the database in the right format.
>
>
>