insert date with now()

[mrtme]

I'm trying to insert the current date with the now() function, this is the insert with fields, i'm a bit lost as to how this would work, can anyone help a clueless newbie?

$sql="INSERT INTO links (name, country, city, address, rating, size, date)
VALUES
('$_POST[name]','$_POST[country]','$_POST[city]','$_POST[address]','$_POST[rating]','$_POST[size]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con)
?>

[chazzy]

should be..


$sql="INSERT INTO links (name, country, city, address, rating, size, date)
VALUES
('$_POST[name]','$_POST[country]','$_POST[city]','$_POST[address]','$_POST[rating]','$_POST[size]',NOW())";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con)
?>