Re: php or Mysql for DATE?
| From: | David Robley | Date: | Thu, 15 Mar 2001 07:31:58 +0000 |
| Subject: | Re: php or Mysql for DATE? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-43988@lists.php.net to get a copy of this message | ||
On Thu, 15 Mar 2001 17:49, Dhaval Desai wrote:
> I want to have a posting column wherein people can
> post their messages and when a new message is posted
> the Curent date has to be added in the mysql database.
>
> Do u think I should use Php to generate the date or
> should I have mysql to generate the date.
>
> I am also going to allow people to search for messages
> as per date. For example
>
> Search for messasges in the last week and stuff..
>
>
> Please advice me..
>
Have a look at the mysql manual in particular the date/time data types
and how some can be automatically updated.
--
David Robley | WEBMASTER & Mail List Admin
RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/
AusEinet | http://auseinet.flinders.edu.au/
Flinders University, ADELAIDE, SOUTH AUSTRALIA