Re: Inserting time + date entry into mySQL DB
| From: | elias | Date: | Tue, 10 Apr 2001 23:23:03 +0000 |
| Subject: | Re: Inserting time + date entry into mySQL DB | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-48016@lists.php.net to get a copy of this message | ||
No under windows doesn't work.
you have to enter a value in that field with value NOW()
-elias
http://www.kameelah.org/eassoft
"Michael Hall" <lists@mulga.com.au> wrote in message
news:Pine.LNX.4.10.10104102051270.15611-100000@localhost.localdomain...
>
>
> 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?
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>