Forum Moderators: open
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]
try this:
INSERT INTO students (date_reg, expire_date) VALUES (NOW(), DATE_ADD(NOW(), INTERVAL 12 MONTHS))
[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]
