adding a form submission date in mysql...

[buddysal]

not sure how to do this... i tried to put the date as an array, then use $date in all the field areas to submit it to my database under date.. but it didnt work...

[Gargouil]

What exactly are you triing to do ?

if you want to play with date use time() to get the timestamp
with this, you can do what you want with date()

[buddysal]

im trying to get a date submitted with my form into my mysql so i can see what date the form was submitted..

[PyroX]

<?
echo date("m/d/Y");
?>

[cgraz]

or use mysql's own now()

Cgraz

[buddysal]

pyro i know how to do that... but i need to submit it to my mysql database.. not just echo it on my site...

[PyroX]

<?
$date=date("m/d/Y");
?>

$query="INSERT INTO database (date) VALUES ('$date')";

[buddysal]

thanks pyro, I will try that.. sorry im alittle new to the whole mysql thing..

[buddysal]

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/buddysal/public_html/form.php on line 78

i get that... do i need to add the coding at the very end of the whole script.. and reopen php and have it run its one thing....?

like this

<?PHP
mainscript
?>
<?PHP
date
?>

?