Envoyer des donnée dans une table via un form

if (isset( $_POST['logementenvoyer'] ) ){ // utilisation d'un bouton formulaire pour envoyer les informations. ici "ajoutecole"
			
		$nom3 = mysql_real_escape_string($_POST ['nom3']);
		$prenom3 = mysql_real_escape_string($_POST ['prenom3']);
		$statut3 = mysql_real_escape_string ($_POST ['statut3']);
		$adresseproprietaire3 = mysql_real_escape_string ($_POST ['adresseproprietaire3']);
		$fixe3 = mysql_real_escape_string($_POST ['fixe3']);
		$mail3 = mysql_real_escape_string($_POST ['mail3']);
		$location3 = mysql_real_escape_string($_POST ['location3']);
		
		$jour3 = mysql_real_escape_string($_POST ['jour3']);
		$mois3 = mysql_real_escape_string($_POST ['mois3']);
		$annee3 = mysql_real_escape_string($_POST ['annee3']);
		
		
		
		//$annee2 = mysql_real_escape_string($_POST ['annee']);
		//$mois2 = mysql_real_escape_string($_POST ['mois']);
		//$jour2 = mysql_real_escape_string($_POST ['jour']);
		
		
		$type3 = mysql_real_escape_string($_POST ['typecontrat3']);
		
		$type3 = mysql_real_escape_string($_POST ['typelogement3']);
		
		$surface3 = mysql_real_escape_string($_POST ['surface3']);
		$etage3 = mysql_real_escape_string($_POST ['etage3']);
		//$meuble3 = mysql_real_escape_string($_POST ['meuble3']);
		$meubleradio3 = mysql_real_escape_string($_POST ['meubleradio3']);
		$cuisine3 = mysql_real_escape_string($_POST ['cuisine3']);
		$cuisine3 = mysql_real_escape_string($_POST ['cuisine3']);
		$ascenseur3 = mysql_real_escape_string($_POST ['ascenseur3']);
		$bain3 = mysql_real_escape_string($_POST ['bain3']);
		$wc3 = mysql_real_escape_string($_POST ['wc3']);
		$parking3 = mysql_real_escape_string($_POST ['parking3']);
		$transport3 = mysql_real_escape_string($_POST ['transport3']);
		$chauffage3 = mysql_real_escape_string($_POST ['chauffage3']);
		$handicape3 = mysql_real_escape_string($_POST ['handicape3']);
		$loyer3 = mysql_real_escape_string($_POST ['loyer3']);
		$charges3 = mysql_real_escape_string($_POST ['charges3']);
		$depot3 = mysql_real_escape_string($_POST ['depot3']);
		$divers3 = mysql_real_escape_string($_POST ['divers3']);
		$nbrecoloc3 = mysql_real_escape_string($_POST ['nbrecoloc3']);
		//$google3 = mysql_real_escape_string($_POST ['google3']);


if ($nom3 == '') $error = '<br />Compléter les champs Obligatoire';

		if ($error ==''){
			$sql ="INSERT INTO formulaire  (formNom,
									  formPrenom,
									  formStatut,
									  formAdresseProprietaire
									  formFixe,
									  formPorte,
									  formMail,
									  formLocation,
									  formDateDispo,
									  formExpiration,
									  formDate,
									  
									  formTypeContrat
									  
									  formTypeLogement,
									  
									  formSurface, 
									  formEtage,
									
									  formMeubleradio,
									  formCuisine,
									  formAscenseur,
									  formBains,
									  formWc,
									  formParking,
									  formTransport,
									  formChauffage,
									  formHandicape,
									  formLoyer,
									  formCharges,
									  formDepot,
									  formDivers,
									  formClient,
									  formVisuel,
									  formGoogle,
									  formVisuel2,
									  formVisuel3,
									  formVisuel4) 
				   VALUES ('$nom3',
						   '$prenom3',
						   '$statut3',
						   '$adresseproprietaire',
						   '$fixe3',
						   '$porte3',
						   '$mail3',
						   '$location3',
						   '$datelocation3',
						   '$expiration3',
						   '$date3',
						   
						   '$typecontrtat3',
						   
						   '$typelogement3',
						   
						   '$surface3',
						   '$etage3',
						   
						   '$meubleradio3',
						   '$cuisine3',
						   '$ascenseur3',
						   '$bains3',
						   '$wc3',
						   '$parking3',
						   '$transport3',
						   '$chauffage3',
						   '$handicape3',
						   '$loyer3',
						   '$charges3',
						   '$depot3',
						   '$divers3',
						   '$client3',
						   '$visuel',
						   '$google3',
						   '$visuel2',
						   '$visuel3',
						   '$visuel4',
						   '$nombrecolocataires')"; 
			$query = mysql_query($sql);
			
			header('location:logement.php');
			
		}
	
}