Auto record of date

--QBEJLPOmywvPAPrxDCbincVtVaS
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi
I have a problem trying to get the date entered into a table from a
simple form which is only asking for an email address.

By my reading of the manual TIMESTAMP should do this for me each time a
row of fields are changed but it doe not appear to do so. Using MySql
with the form from a php page.

Some suggestions appreciated

Cheers
Chris



--QBEJLPOmywvPAPrxDCbincVtVaS--

RE: Auto record of date

chris;

you may have your timestamp set to trigger with new records only.

perhaps if you created a 'changed_date' in that same table, then
triggered an update with 'any' changes (page on dirty, on update, etc.)
your email addresses 'change event' could provide what you are looking =
for.

john

-----Original Message-----
From: Chris Lloyd [mailto:serendipity@xtra.co.nz]
Sent: Tuesday, October 04, 2005 11:46 AM
To: win32@lists.mysql.com
Subject: Auto record of date


Hi=20
I have a problem trying to get the date entered into a table from a
simple form which is only asking for an email address.

By my reading of the manual TIMESTAMP should do this for me each time a
row of fields are changed but it doe not appear to do so. Using MySql
with the form from a php page.

Some suggestions appreciated

Cheers
Chris



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: Auto record of date

Thanks John

I actually do want the date recorded when a new record is entered.

Cheers
Chris



-----Original Message-----
From: John Theroux [mailto:john@northerninnovators.com]
Sent: Wednesday, 5 October 2005 8:56 a.m.
To: Chris Lloyd; win32@lists.mysql.com
Subject: RE: Auto record of date
Importance: High


chris;

you may have your timestamp set to trigger with new records only.

perhaps if you created a 'changed_date' in that same table, then
triggered an update with 'any' changes (page on dirty, on update, etc.)
your email addresses 'change event' could provide what you are looking
for.

john

-----Original Message-----
From: Chris Lloyd [mailto:serendipity@xtra.co.nz]
Sent: Tuesday, October 04, 2005 11:46 AM
To: win32@lists.mysql.com
Subject: Auto record of date


Hi
I have a problem trying to get the date entered into a table from a
simple form which is only asking for an email address.

By my reading of the manual TIMESTAMP should do this for me each time a
row of fields are changed but it doe not appear to do so. Using MySql
with the form from a php page.

Some suggestions appreciated

Cheers
Chris



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=serendipity@xtra.co.nz


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org