`telephone` int(10) NOT NULL,

ALTER TABLE  `benevoles` CHANGE  `telephone`  `telephone` VARCHAR( 14 ) NOT NULL

Aaaaaargh !!! (Tout ca pour ca!)

Un grand merci a toi !

$_POST = array_map('mysql_real_escape_string', $_POST );

--
-- Structure de la table `benevoles`
--

CREATE TABLE IF NOT EXISTS `benevoles` (
  `dejaete` varchar(3) NOT NULL,
  `nom` varchar(25) NOT NULL,
  `prenom` varchar(25) NOT NULL,
  `adresse` varchar(60) NOT NULL,
  `code` int(5) NOT NULL,
  `ville` varchar(30) NOT NULL,
  `telephone` int(10) NOT NULL,
  `email` varchar(30) NOT NULL,
  `amontjour` varchar(50) NOT NULL,
  `amonthoraires` varchar(40) NOT NULL,
  `vendredi` varchar(50) NOT NULL,
  `vendredihoraires` varchar(40) NOT NULL,
  `samedi` varchar(50) NOT NULL,
  `samedihoraires` varchar(40) NOT NULL,
  `apresjour` varchar(50) NOT NULL,
  `apreshoraires` varchar(40) NOT NULL,
  `groupes` varchar(60) NOT NULL,
  `comdispo` varchar(60) NOT NULL,
  `experience` varchar(60) NOT NULL,
  PRIMARY KEY  (`nom`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO benevoles SET dejaete='oui' nom='DUPOND', prenom='Jeanette', adresse='Champ Elysée', code='75000', ville='PARIS', telephone='0606060606', email='[email protected]', amontjour='Soirs', amonthoraires='Apres 18h', vendredihoraires='A partir de midi', samedihoraires='A partir de midi', apresjour='Week-end', apreshoraires='Tous les jours', groupes='100 Grammes de Têtes, Alif Sound System, Red Eyes Band, Bal Pygmée...', comdispo='Je ne bosse plus à ce moment la', experience='les autres festival dulardon pardi !'

INSERT INTO benevoles SET
dejaete='oui'
nom='DUPOND',
prenom='Jeanette',
adresse='Champ Elysée',
code='75000',
ville='PARIS',
telephone='0606060606',
email='[email protected]',
amontjour='Soirs',
amonthoraires='Apres 18h',
vendredihoraires='A partir de midi',
samedihoraires='A partir de midi',
apresjour='Week-end',
apreshoraires='Tous les jours',
groupes='100 Grammes de Têtes, Alif Sound System, Red Eyes Band, Bal Pygmée...',
comdispo='Je ne bosse plus à ce moment la',
experience='les autres festival dulardon pardi !'
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'nom='DUPOND',
prenom='Jeanette',
adresse='Champ Elysée',
code='75000',
ville' at line 3

echo $requete; 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'nom='DUPOND',
prenom='Jeanette',
adresse='Champ Elysée',
code='75000',
ville' at line 3

<?php
$dejaete = $_POST['dejaete'];
$nom = $_POST['nom'];
$prenom = $_POST['prenom'];
$adresse = $_POST['adresse'];
$code = $_POST['code'];
$ville = $_POST['ville'];
$telephone = $_POST['telephone'];
$email = $_POST['email'];
$amontjour = $_POST['amontjour'];
$amonthoraires = $_POST['amonthoraires'];
$vendredihoraires = $_POST['vendredihoraires'];
$samedihoraires = $_POST['samedihoraires'];
$apresjour = $_POST['apresjour'];
$apreshoraires = $_POST['apreshoraires'];
$groupes = $_POST['groupes'];
$comdispo = $_POST['comdispo'];
$experience = $_POST['experience'];

$connexion = mysql_connect("host","id","mdp");
mysql_select_db("base",$connexion);

$requete = "INSERT INTO benevoles SET
dejaete='$dejaete'
nom='$nom'
prenom='$prenom'
adresse='$adresse'
code='$code'
ville='$ville'
telephone='$telephone'
email='$email'
amontjour='$amontjour'
amonthoraires='$amonthoraires'
vendredihoraires='$vendredihoraires'
samedihoraires='$samedihoraires'
apresjour='$apresjour'
apreshoraires='$apreshoraires'
groupes='$groupes'
comdispo='$comdispo'
experience='$experience'";
mysql_query($requete) or exit('<pre>' . $requete  . PHP_EOL . mysql_error() . '</pre>');

echo "<h2>Vos données ont été envoyées !</h2>";
echo "<p class='texte'><a href='benevoles-inscription2.php'>Retour au formulaire</a></p><br><br>";

// fermeture de la connexion vers Mysql
mysql_close();
?>

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'nom='DUPONT'
prenom='Jeanette'
adresse=Champ Elysée'
code='75000' at line 3