Re: Inserting time + date entry into mySQL DB
| From: | Michael Hall | Date: | Tue, 10 Apr 2001 11:24:58 +0000 |
| Subject: | Re: Inserting time + date entry into mySQL DB | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-48010@lists.php.net to get a copy of this message | ||
Create a field in your table called something like 'date' and make its
data type TIMESTAMP. MySQL will automatically add a timestamp with each
new entry ... assuming you're using UNIX, I don't know about windows.
Mick
> I know this has been brought up repeatedly but I couldn't find the archives website.
> I'm doing a news publishing script (something like newsphp \ php-nuke) but uses mySQL to
> store all the data instead of flat files.
> I would like to make it such that everytime I submit an news entry, the time\date will
> automatically be inserted in that row.
> Could someone give me some suggestions?