[RESOLVED] How to add date into db

[NZ_Kiwis]

I've got a mySQL database, a field called StartDate and it's type is just date.

This is my PHP insert code echo'd out

UPDATE `mygroups` SET `GroupName` = 'Hockey', StartDate = 2013-08-25, EndDate = 2013-08-25 WHERE ID = 1

THis is my raw code

$result = mysql_query("UPDATE `mygroups` SET `GroupName` = '$GroupName', StartDate = $Start, EndDate = $End WHERE ID = $GroupID") or die(mysql_error());

I can update my Group name but my date's don't update - why?

[bradgrafelman]

First problem I see is that the integer 1980 is not a valid value for a Date column, and that's the value you're attempting to use for both StartDate and EndDate in the query you posted above. (Hint: 2013 minus 8 minus 25 equals 1980. 😉)

Dates are strings; the dates in your query are missing single quotes around them.

[NZ_Kiwis]

OMG I knew that and was staring at my code far too long.