Add date (using the php date()) to the MySQL

[bor003]

Hi,
I have made a registration for and have got it all working I have just not managed to make the date show up properly…
in my MySQL there is the column "dateJoined" which is formatted as DATE and this is the PHP

Code:

$acceptHash = —
$acceptHash .=–
// cannot get this to show up!
$date=date(“Ymd”);

$addToDatabase = “INSERT INTO `–`.`users`
(—-`dateJoined`)
VALUES (
—-
‘$date’

);”;

mysql_query($addToDatabase);

in the database it show:

[img]http://grab.by/6da[/img]

any way to get the date formatted right?

[cybershot]

what if you did this

$date = date(“Ymd”);

instead of this

$date=date(“Ymd”);

[bor003]

Found out how :)

Using:
$date = date("Y-m-d");
now.

Thanks for your help though

[Author]

Posts