[RESOLVED] converting dates in an array

[PABobo]

I am having a problem converting a set of dates in an array. It keeps zeroing out the other values and gives me a date of 1961-12-31. Here is what i have as the script can anyone tell me what is going on and how to resolve this?

for($i=1;$i<$POST['total']+2;$i++)
{
$insert_array[] = "('" . $date1[$i] . "','" . $qty[$i] . "','" . $gift[$i] . "','" . $fmv[$i] . "','" . $member[$i] . "','" . $npv[$i] . "','" . $ncpg[$i] . "','" . $notes[$i] . "')";
$date1_total = $date1[$i];
$qty_total = $qty[$i];
$gift_total = $gift[$i];
$fmv_total = $fmv[$i];
$member_total = $member[$i];
$npg_total = $npg[$i];
$ncpg_total = $ncpg[$i];
$notes_total = $notes[$i];
}
$d = strtolower(date(F));
$gifts = "gifts";
$res_date = date('Y-m-d'), strtotime($date1_total);
$insert_array[] = "('" . $res_date. "','" . $qty_total . "','" . $gift_total . "','" . $fmv_total . "','" . $member_total . "','" . $npg_total . "','" . $ncpg_total . "','" . $notes_total . "')";
mysql_select_db($database_vp, $vp) or die(mysql_error());
$sql = "INSERT INTO $d$gifts (gift_order_date,gift_order_total,gift_id,gift_order_fmv,member_profile_id,gift_order_npv,gift_order_ncpg,gift_notes) VALUES " . implode(",",$insert_array);
mysql_query($sql, $vp) or die("could not execute INSERT query");

[subwayman]

Dates in queries are always a bit of fun. To find out what it going wrong echo out every date as it is created. you will then find where the problem lies.

[PABobo]

thank you for that idea. My brain was fried. I was able to resolve it by moving the strtotime to the begining of the array structure. i did have another problem that would enter the last value in twice and also add blanks i just added 2 more arrays in the list and deleted all 0 values in the total field. Probably not the best way to do it but it's working effeciently.
for($i=0;$i<17;$i++)
{
$getdate = date("Y-m-d",strtotime($date1[$i]));
$insert_array[] = "('" . $getdate . "','" . $qty[$i] . "','" . $gift[$i] . "','" . $fmv[$i] . "','" . $member[$i] . "','" . $npv[$i] . "','" . $ncpg[$i] . "','" . $notes[$i] . "')";
$date1_total = $getdate;
$qty_total = $qty[$i];
$gift_total = $gift[$i];
$fmv_total = $fmv[$i];
$member_total = $member[$i];
$npg_total = $npg[$i];
$ncpg_total = $ncpg[$i];
$notes_total = $notes[$i];
}
$d = strtolower(date(F));
$gifts = "_gifts";
$insert_array[] = "('" . $date1_total . "','" . $qty_total . "','" . $gift_total . "','" . $fmv_total . "','" . $member_total . "','" . $npg_total . "','" . $ncpg_total . "','" . $notes_total . "')";
mysql_select_db($database_vp, $vp) or die(mysql_error());
$sql = "INSERT INTO $d$gifts (gift_order_date,gift_order_total,gift_id,gift_order_fmv,member_profile_id,gift_order_npv,gift_order_ncpg,gift_notes) VALUES " . implode(",",$insert_array);
mysql_query($sql, $vp) or die("could not execute INSERT query");