Using Mysql Functions in Queries

[djcomplex]

ola!
im working on a v v simple news submittion script what i wanted to do was ure the Mysql Functions CURDATE() and CURTIME() to do my timestamps for me i.e

$query = "insert into tblname values ('"$var1"','"$etc"','CURDATE()','CURTIME()')";

however it seems to treat it as a php function and goes call to undefined function

any ideas?

[djcomplex]

success i got it working

[jweissig]

please post the working code so that others can learn.

thanks,
- justin

[djcomplex]

query = "insert into tblname values ('"$var1"','"$etc"',CURDATE())";