add date?

[lting]

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 ..

[lting]

the date format is my sql table is


YEAR/Month/Day also
2004-01-12 ...

[pyro]

For extensibility, might I recommend entereing the dates in a timestamp, and doing your formatting on the way out of the DB...

[lting]

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

[pyro]

Yes, you should be able to do so by changing your query to something like this:

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

[lting]

emm not working ...

???

[pyro]

Any error messages?

[lting]

no error message
just it can't save into database ..

don't know what's wrong ..