Wrox Programmer Forums
Go Back   Wrox Programmer Forums > PHP/MySQL > MySQL
| Search | Today's Posts | Mark Forums Read
MySQL General discussion about the MySQL database.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 3rd, 2006, 04:47 PM
Registered User
 
Join Date: Jan 2006
Location: St. Paul, MN, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Creating an auto update date field

I have a database table that is updated via a web form. How do I create a field in the database table that will automatically enter in the date of the entry, to a field, called "Date"....I am using phpMyAdmin?
 
Old January 4th, 2006, 02:32 AM
Friend of Wrox
 
Join Date: Mar 2004
Location: Bhopal, MP, India.
Posts: 357
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to anshul
Default

Either insert it by getting current time using a PHP function like strftime().

Or create a MySQL field (may be of length 14 chars) applying MySQL built-in timestamp function.



`~@#\^%&*/\.<.\/-|+|_!:;..=?>
Students' finances
 
Old January 4th, 2006, 11:34 AM
Registered User
 
Join Date: Jan 2006
Location: St. Paul, MN, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the reply.

I would like to use the option of:
"Creating a MySQL field and applying the built-in timestamp function.

I am working with MySQL via, phpMyAdmin....

I don't know how to set up the time stamp function. Do you have documentation on that?
 
Old January 4th, 2006, 03:12 PM
Friend of Wrox
 
Join Date: Mar 2004
Location: Bhopal, MP, India.
Posts: 357
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to anshul
Default

Quote:
quote:I don't know how to set up the time stamp function.
It is as simple as:
INSERT into table_name(field1, field2) VALUES('$var1', 'timestamp()')

Note that PHP has no function timestamp(). It is of MySQL.

Use phpMyAdmin to easy manage all these things.

`~@#\^%&*/\.<.\/-|+|_!:;..=?>
Students' finances




Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Date Field desireemm Access 1 October 16th, 2005 12:25 AM
Trying to update a date field jfrizelle Classic ASP Databases 3 November 4th, 2004 08:55 AM
Auto update timestamp field TwoNames PHP Databases 2 September 26th, 2004 06:01 PM
Update a date field levinll SQL Language 1 January 16th, 2004 02:41 PM
auto update table field nkrukovsky Access VBA 2 November 4th, 2003 05:28 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.