add date?

@ltingJan 12.2004

what is the php command to add today’s date into my mysql database?

i try

$updateCurrency = “UPDATE currencyrate SET currencyid=’$currencyid’, currencyname=’$currencyname’, exchangerate=’$exchangerate’, lastupdate=date(‘Y-m-d’) WHERE pkey = “.$pkey;

but it not working ..

the type of date inside my mysql table is DATE not varchar ..

to post a comment

PHP

@ltingauthorJan 12.2004 — #the date format is my sql table is

YEAR/Month/Day also

2004-01-12 ...

@pyroJan 12.2004 — #For extensibility, might I recommend entereing the dates in a timestamp, and doing your formatting on the way [i]out[/i] of the DB...

@ltingauthorJan 12.2004 — #emmm

but the database had been created ... if i want to remain unchange on the database .. is it any possible way to do that?

emm but your suggestion is good .. i should tell my team members .. but currently i hope can remain unchange on the database

@pyroJan 12.2004 — #Yes, you should be able to do so by changing your query to something like this:

[code=php]$updateCurrency = "UPDATE currencyrate SET currencyid = '$currencyid', currencyname = '$currencyname', exchangerate = '$exchangerate', lastupdate= ".date('Y-m-d')." WHERE pkey = '$pkey';";[/code]

@ltingauthorJan 12.2004 — #emm not working ...

???

@pyroJan 12.2004 — #Any error messages?

@ltingauthorJan 13.2004 — #no error message

just it can't save into database ..

don't know what's wrong ..

add date?

7 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

add date?

7 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

7 Comments(s) _↴

Also in #PHP _↴