CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Automatic Date entry

Print topic Send  topic

Author Message
Ed Lentz
Posted: 11/09/2003, 8:22 AM

Hi
I have a MySql DB, using PHP, and CCS2. How could I enter a date in a field in my MySql table when I update a record? Is there a FAQ or Tutorial?

Thanks

Ed
ryan
Posted: 11/19/2003, 3:54 AM

There is a timestamp data type in MySQL right? Can you try that please set a database field to a timestamp :)
StephenK
Posted: 11/19/2003, 6:00 AM

Select your record
On your data tab select custom update type > table
Click on custom update
Hit the + next to parameters

-field is Date or DateTime field in Table; type > text
-parameter source is type > code expression; name > 'now()'






bb
Posted: 11/19/2003, 11:23 PM

Assuming that you want to default a date to 12/31/2037 - do this

set the default value to: mktime(0,0,0,12,31,2037)

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.