mysql and access unix timestamp?

[marksie1988]

ok i basically want a form to post a unix timestamp into my mysql database when i change or add any entries is this possible if so how?

im good with php and mysql but dont realy use access so please tell me exactly how to do this

Cheers
Steve

 

[RuralGuy]

In the BeforeUpdate event of your form put:
Me.YourEpochField = DateDiff("s",#1/1/1970#,Now)

 

[marksie1988]

i have just tried that and doesnt seem to work i changed the

Me.YourEpochField = DateDiff("s",#1/1/1970#,Now)

Me.postdate = DateDiff("s",#1/1/1970#,Now)

and i put it in the postdate field for the form and in general and still didnt work

 

[RuralGuy]

What do you mean when you say "It didn't work"? When you put:
?DateDiff("s",#1/1/1970#,Now) in the immediate window, what happens? Is the Me.postdate control bound to a field in the table?