[PHP] Re: How to insert time and date into mysql?

2003-02-07 Thread Daniel Page
The easiest way is to create a timestamp field (see manual depending on how you want to store the date, as you can go from to ddmmhhmmss...), and when you create your DB update query, use now(). for example, update a field with a new email address, and the user's current ip with the time

Re: [PHP] RE: How to insert time and date into mysql?

2001-03-01 Thread Kevin Cawthorne
Why not use the CURDATE() and CURTIME() functions built into mysql? Kevin Cawthorne - Original Message - From: "Foley, John" [EMAIL PROTECTED] To: "'Zenith'" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 01, 2001 2:20 PM Subject: [PHP] RE: How to insert time and date into

RE: [PHP] RE: How to insert time and date into mysql?

2001-03-01 Thread Foley, John
Why not use the CURDATE() and CURTIME() functions built into mysql? Because my filing system requires that the filename.extension be datetime.extension in the PHP LP script (lazy man's serialization). That way, I can just referance the datetime when I build my table of