[Dates] pb avec date et mktime

Code:

1
2
3
4
5
  $duree = duree_voyage($planete_d,$a_capitale);
  $date_depart = date("Y-m-d H:i:s");
  $date_arrivee = date("Y-m-d H:i:s", mktime(date("Y"), date("m"), date("d")+$duree, date("H"), date("i"), date("s")));
  $req_ccl = mysql_query("INSERT INTO attaques SET type = 3, players = \"$a_players\", planete_a = \"$planete_d\", planete_d = \"$planete_a\", u11 = \"$a_u11\", u12 = \"$a_u12\", u13 = \"$a_u13\", u14 = \"$a_u14\", u15 = \"$a_u15\", u16 = \"$a_u16\", u21 = \"$a_u21\", u31 = \"$a_u31\", u32 = \"$a_u32\", u33 = \"$a_u33\", u41 = \"$a_u41\", u42 = \"$a_u42\", u43 = \"$a_u43\", u44 = \"$a_u44\", h_depart = \"$date_depart\", h_arrivee = \"$date_arrivee\"") or die("l.234 - req_ccl<br>".mysql_error());
  echo("INSERT INTO attaques SET type = 3, players = \"$a_players\", planete_a = \"$planete_d\", planete_d = \"$planete_a\", u11 = \"$a_u11\", u12 = \"$a_u12\", u13 = \"$a_u13\", u14 = \"$a_u14\", u15 = \"$a_u15\", u16 = \"$a_u16\", u21 = \"$a_u21\", u31 = \"$a_u31\", u32 = \"$a_u32\", u33 = \"$a_u33\", u41 = \"$a_u41\", u42 = \"$a_u42\", u43 = \"$a_u43\", u44 = \"$a_u44\", h_depart = \"$date_depart\", h_arrivee = \"$date_arrivee\"");

admettons que $durée = 3 ...
$date_depart = 2005-09-08 21:25:25

$date_arrivee = 2005-09-11 21:25:25

sauf que moi ça me retourne

Citation:

INSERT INTO attaques SET type = 3, players = "2436986389", planete_a = "218", planete_d = "374", u11 = "1", u12 = "0", u13 = "0", u14 = "0", u15 = "0", u16 = "0", u21 = "0", u31 = "0", u32 = "0", u33 = "0", u41 = "1", u42 = "0", u43 = "0", u44 = "0", h_depart = "2005-09-08 21:25:25", h_arrivee = "2026-12-17 13:09:08"