I'm pushing values into a MySQL database I need to take the code I have now and integrate the STR_TO_DATE()
function.
The STR_TO_DATE()
function needs to be applied to both $start
& $end
.
$qstring = "INSERT INTO tbl_events VALUES(NULL,'".$name."','".$day."','".$start."','".$end."','".$location."','".$description."','".$type."')";
$result = mysql_query($qstring);
Date Format is "08/03/2011 09:05"
I've already tried replacing $start
with STR_TO_DATE($start)
it kills the php script.