[Resolved] Current Date

[MichaelHe]

I have a database without a Date field.

When I run the Insert.php file I have created, I write the data in the forms and click submit. Then the data is inserted in my database.

Now I need a Date on each post, saying when they are created.
How do I do that. ?

I have now created a Date field in the structure. Do I now have to sent the current date (somehow) to the database, from my Insert.php file, or can I get the database to automaticly write the current date in the Date field when a new post is created.

And do I do either of the above solutions.. ?

Michael

[liquorvicar]

i haven't tested this but it should work:

$sql = "INSERT INTO myTable (myFields...,myDateField) VALUES ('values'...,NOW())";

[MichaelHe]

Yes, it works..

Thank you very much 🙂