ผมเขียน php ทำการ insert data เขียนไปแบบนี้ครับ ... ใช่ NULL DATE date ไม่ 0000-00-00

				
  $date = date("Y-m-d");
  $sql = "insert into order values ('',$ID_CUSTOMER, $total_price, '$date')";
  $result = mysql_query($sql);
  if (!$result)
    return false;

  $sql = "select ID_ORDER from order where ID_CUSTOMER = $ID_CUSTOMER and AMOUNT > $total_price-.001 and AMOUNT < $total_price+.001 and DATE = '$date'";
  $result = mysql_query($sql);
  if(mysql_num_rows($result)>0)
    $ID_ORDER = mysql_result($result, 0, "ID_ORDER");
  else
    return false; 
	
  // ป้อนรายละเอียดของ Design 
    foreach ($cart as $ID_PRODUCT => $qty)
	{
    $book = get_book_details($ID_PRODUCT);
	$conn = connect_db("ksnasia");
	$sql="insert into order_item values ($ID_ORDER,'$ID_PRODUCT ',$qty)";
    $result = mysql_query($sql);
	   if(!$result)
	   return false;
	}
  return $ID_ORDER;
}