Page 3 of 5

Insert in Week Planner

PostPosted: Tue Aug 03, 2010 2:26 pm
by fahad.direct
Insert query works but it is losing the parameters and no values in description, bg color code and Dates are being received though in my insert query as:

$sql = "insert into weekSchedule(description,bgColorCode,eventStartDate,eventEndDate)
values('".$description."','".$_GET['bgColorCode']."','".date("Y-m-d H:i:s",strtotime($_GET['eventStartDate']))."','".date("Y-m-d H:i:s",strtotime($_GET['eventEndDate']))."')";
//mysql_query($sql);

$id = mysql_insert_id($db);

Kindly if some one can help me out.