Jennifer Gardner wrote: > I have looked at the info supplied by your links and am still struggling. > So, if the offer still stands I would love to check out the examples and see > if that helps. I understand (to a degree) how to get the date via php but I > just do not understand how to submit it to the database. The site I am > trying to do it for is - HYPERLINK > "http://www.ihaveplayeddiscgolf.com/"http://www.ihaveplayeddiscgolf.com/ > Thanks again for your assistance, > Jennifer
Hello Jennifer, I looked Jamal's post and NOW() works the same way as current_date. I don't know what the difference is but I have always used NOW(). Here is your example: INSERT INTO `table123` ( `ID` , `CheckedIn`) VALUES ( NULL , NOW() ); Now you can retrieve the information using DATE_FORMAT select DATE_FORMAT(CheckedIn, '%Y%m%d') AS Date from table123 Hope this makes it clear. -- John
