Date Functions

[adammc]

Hi guys,

Can anyone please help me with this:

The SQL insert (date functions) didnt work :( All I am getting is the following:

0000-00-00 00:00:00 (instead of correct dates)

[PHP]$query = "INSERT INTO students (

date_reg,
expire_date) VALUES (

NOW()',
'DATE_ADD(NOW(), INTERVAL 12 MONTH')";

$result = @mysql_query ($query);
[/PHP]

[phranque]

looks like extraneous quotes, mismatched parentheses and missing 'S'.

try this:

INSERT INTO students (date_reg, expire_date) VALUES (NOW(), DATE_ADD(NOW(), INTERVAL 12 MONTHS))

[adammc]

thanks for the reply, i got it sorted using:

[PHP]// format the date & time
$now = time();
$thisYear = date("Y-m-d H:i:s", $now);
$nextYear = date("Y-m-d H:i:s", strtotime("+12 months"));[/PHP]