[Resolved] I wanna add the current date to my sql table..

[The_Stranger]

How on earth is that done?

This is how I tried:

$statement ="insert into news (topic, newsText, source, sourceHttp, d) values ('$topic', '$content', '$source', '$www', '$date')";

oh yeah.. and I tried with
$date=date("Ymd");

but many other types too.😕

[csn]

Hmm, now this is a tough one...

[The_Stranger]

hmm.. I was browsing through that page.. but somehow I didnt find it out anyhow... There's only selectstatements and I get them to work fine.. but then when I try to insert it to the table it wont work... 😕

[csn]

$statement ="insert into news (topic, newsText, source, sourceHttp, d) values ('$topic', '$content', '$source', '$www', now())";

CURDATE() 
CURRENT_DATE 
CURRENT_DATE()

NOW() 
SYSDATE() 
CURRENT_TIMESTAMP 
CURRENT_TIMESTAMP() 
LOCALTIME 
LOCALTIME() 
LOCALTIMESTAMP 
LOCALTIMESTAMP()  

[csn]

Originally posted by The_Stranger
oh yeah.. and I tried with
$date=date("Ymd");

To work, this would need to be:

$date=date("Y-m-d");

[The_Stranger]

Thanks.. 🆒