Date and time stuffing up

[Anon]

i have used this code to grab the date and time its hidden.

<input name="date" type="hidden" value="<?php echo date("D dS M,Y h:i a"); ?>">

and this one to print it

<?php echo $row_Recordset1['date']; ?>

but it comes out like this

0000-00-00 00:00:00

why

in the MYSQL database their is a field called date with the datetime

aron.

[Anon]

There's nothing wrong with the code. I think your problem is in the array $row_Recordset1. Try to validate if it has values using the isset() function, and trace back how you placed values into it. Regarding MySQL, it could also be that the date inserted to it is not the value you've generated with the date() function instead the date in MySQL.