For the life of me I can't get the current date to insert into my table. I would like a "submitted date" to be stored upon the creation of the record. I've tried countless different ways to achieve this and every time I get no results in the table, just the default 0000-00-00 (it's set to date). Being completely new to this I'm positive I'm doing some completely wrong, I just can't figure out what.
// Insert fields into XINFO $sql = "INSERT INTO xinfo SET date_submit='$dsub', //<-- set to $dsub = 'CURDATE()'; first_name='$fn', last_name='$ln', city='$city', state_province='$state', country='$cntry', other_country='$ocntry', dob='$dob', email='$em'"; // execute query $result = mysql_query($sql);