Timestamp wth MY sql

[Simon]

I have my database on a Mysql server

The timestamp field does not work when data from my website is writen
to the database

I have a form on my website that lets people fill out brochure request
and puts data into mysql


What could be stopping it from putting a timestamp on it all

Thanks

 

[Tony Toews [MVP]]

I have my database on a Mysql server

The timestamp field does not work when data from my website is writen
to the database

I have a form on my website that lets people fill out brochure request
and puts data into mysql


What could be stopping it from putting a timestamp on it all

Just guessing. Is this field called timestamp? Or is it of timestamp
type? By type other examples would be text, integer, double,
numeric, memo and such.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[aaron.kempf]

isn't it SYSDATE() or something along those lines?

or is it curdate()

something ridiculous like that..

I believe that 90% of the people in the real world when they say
'timestamp' they just mean 'Date/Time = Now()'