From: php-list@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Black
Jennifer Gardner wrote: > Hello, > I am looking for a good tutorial for having the date submitted when a form > is submitted and then being able to display the date in a results > table/page. Basically, when the form is submitted I want the date submitted > into the mysql table and then I want to display that on a results page. > Thank you in advance for your help. > Jennifer That should be pretty simple, when you INSERT your data into mysql, add NOW() to insert the current time stamp. HYPERLINK "http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#functio n_now"http://dev.mysql.-com/doc/refman/-5.0/en/date--and-time--functions.-ht ml#function_-now Retrieving is just as easy with dateformat HYPERLINK "http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#functio n_date-format"http://dev.mysql.-com/doc/refman/-5.0/en/date--and-time--funct ions.-html#function_-date-format Let me know if you need help and I will post example MySQL queries. John --------------------- Please remember to write your response BELOW the previous text. ---------------------- Hi John, 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/ Currently the user via the form submits the date. This is causing confusion for signers and so I want the date to automatically be entered and displayed on the results page the same way it is currently displayed. Thanks again for your assistance, Jennifer
