AddDate

[Matthew Emerick-Law]

I am trying to add 4 weeks to a value in my tables using:

$sql_events2 = mysql_query("update users set hosting_date=(SELECT adddate('$hosting_date', 28 DAY)) where username='$username'") or die (mysql_error());

$hosting_date holds the value of the date in the field already that needs 28 days adding to it.

I have tried a few things but I either get errors about my syntax or nothing at all!