Stored Proc - Date not inserting into the Record

I nave 2 stored procedures:

DROP PROCEDURE IF EXISTS `Insert_OHC_Sun`;
DELIMITER $$
CREATE DEFINER=`donw`@`` PROCEDURE `Insert_OHC_Sun`(theDate  
DATE,theDateRaw INT)
BEGIN
       INSERT INTO Office_Hours_Cuttoff  
(ohc_Date,ohc_Date_Raw,Office_Status)
       VALUES (theDate,theDateRaw,"Closed");
END
$$

DROP PROCEDURE IF EXISTS `Insert_OHC_Day`;
DELIMITER $$
CREATE DEFINER=`donw`@`` PROCEDURE `Insert_OHC_Day`(theDate  
DATE,theDateRaw INT)
BEGIN
       INSERT INTO Office_Hours_Cuttoff (ohc_Date,ohc_Date_Raw)
       VALUES (theDate,theDateRaw);
END
$$

Then I have PHP Code to insert a YEAR of days in a table:

     if($_POST['new_year'])  {
     //New Year
     if(in_array($_POST['pick_year'], $ExistingYears))  {
     $Message = "<br>The year ".$_POST['pick_year']." is already  
existing.<br>Please use the DELETE YEAR feature first. Then ADD the  
year again.<br>";
     } else {

     //Add Year
     $first_day = mktime(0,0,0,1, 1, $_POST['pick_year']);
     $last_day = mktime(0,0,0,12, 31, $_POST['pick_year']);

     $cDate = $first_day;
     $num = 1;


     while($cDate <= $last_day) {
    	
     $nDate = Date('Y-m-d', $cDate);

     $db->next_result();
     if(date('D', $cDate) == "Sun") {
         $db->query("CALL Insert_OHC_Sun({$nDate},{$cDate})");
     }else{
        	$db->query("CALL Insert_OHC_Day({$nDate},{$cDate})");
     }

     $cDate+=86400;
     $num++;

     }
     }
     }



The records are inserting into the table BUT the field "och_Dates" is  
not getting the proper value. It gets "0000-00-00".

Frustrating. My code looks right and I echoed the value on the page  
and it is formatted properly. The field in mySQL is formatted as a  
DATE type.

Little help please :-)


Don Wieland
D W   D a t a   C o n c e p t s
~~~~~~~~~~~~~~~~~~~~~~~~~
[email protected]
Direct Line - (949) 305-2771

Integrated data solutions to fit your business needs.

Need assistance in dialing in your FileMaker solution? Check out our  
Developer Support Plan at:
http://www.dwdataconcepts.com/DevSup.html

Appointment 1.0v9 - Powerful Appointment Scheduling for FileMaker Pro  
9 or higher
http://www.appointment10.com

For a quick overview -
http://www.appointment10.com/Appt10_Promo/Overview.html