[SOLVED] mysql date insert

[acctman]

i have a mysql field that is format for DATE 0000-00-00 i was using the code below to added the date but it's not inserting

error: Fatal error: Call to undefined function: curdate()

mysql_query("INSERT INTO rate_referrals (ref_by,ref_mem,ref_set,ref_status,ref_date) 
		VALUES ({$row['m_id']},'$id','$points',0,'".CURDATE()."')");

[JonnoTheDev]

Because it is a MYSQL function not PHP

mysql_query("INSERT INTO rate_referrals (ref_by,ref_mem,ref_set,ref_status,ref_date) 
		VALUES ('".$row['m_id']."','".$id."','".$points."',0,CURDATE()");

[acctman]

thanks that worked perfectly