Hello,

I'm trying to teach myself ASP and MySQL to upgrade one of the websites I run so it's not all in HTML!

I'm currently working on automating the guestbook but i'm having problems with the date. If i'm using datetime ( i think that's the one I'm at work at the momment) how can I get it so that when people submit a form to add there information to the database, The date and time they submit the form is also added. I thought it might be automatic when the form is submitted but it seems to leave those cells blank!

I've mangaged to find answers to all my other enquires in the form of tutorials and guesswork!

use a TIMESTAMP not a DATETIME field. Check out the docs for info about TIMESTAMP. It will store date and time for you. Very easy.

Stephen Cox
web.net geek for nonprofits and political campaigns.

Hello Stephen,

Thank you so much for responding to my query. I didn't realise the answer would be so simple... though I don't midn of course! I think I better find a good book on MqSQL... I could do with some more bed time reading as well!

Regards,
Alex Seal
mailto:
www.irail.co.uk/