Impossible d'ajouter des données a la base de donnée... [Résolu]

Code

mysql_query("INSERT INTO site_upload VALUES('', '$id_user', '$name', '$com', '$link', '$kesako', '$niveau', '', '')");

Code

<?php
if ($user->data['user_id'] != ANONYMOUS){

//verifie l'existance de toute les variable
if(isset($_POST['name']) and $_POST['name'] !=''
and isset($_POST['kesako']) and $_POST['kesako'] !=''
and isset($_POST['niveau']) and $_POST['niveau'] !=''
and isset($_POST['com']) and $_POST['com'] !=''
and isset($_POST['link']) and $_POST['link'] !=''
){
//on attribue les post au variable
$id_user = $user->data['user_id'];
$name = $_POST['name'];
$com = $_POST['com'];
$link = $_POST['link'];
$kesako = $_POST['kesako'];
$niveau = $_POST['niveau'];

echo $id_user;

mysql_connect("localhost", "root", "mysql");
mysql_select_db("data");
mysql_query("INSERT INTO site_upload VALUES('', '$id_user', '$name', '$com', '$link', '$kesako', '$niveau', '', '')");

$donnee = mysql_query("SELECT * FROM phpbb_profile_fields_data WHERE user_id ='$id_user'");
$donfin = mysql_fetch_array($donnee);
echo $donfin['pf_upload'];
$upload = $donfin['pf_upload'] + 1;
echo $upload;
mysql_query("UPDATE phpbb_profile_fields_data SET pf_upload = '$upload' WHERE user_id ='$id_user'");
mysql_close();

?>
<script language="Javascript">
<!--
document.location.replace("test-factis.php");
// -->
</script>
<?php

}else{
?>
<form id="form2" name="inscript" method="post" action=index.php>
<table width="500" border="0">
<tr>
<td><label>Nom du fichier </label></td>
<td>
<input name="name" type="text" size="20" onKeypress="return valid_mail(event);" value="<?php if(isset($_POST['name'])){ echo $_POST['name']; } ?>"/>
</td>
</tr>
<tr>
<td><label>Kesako </label></td>
<td>
<select name="kesako">
<option value="theo">Theorie</option>
<option value="exe">Exercice</option>
<option value="cor">Exercice + Correction</option>
</select>
</td>
</tr>
<tr>
<td><label>Niveau Etude </label></td>
<td>
<select name="niveau">
<option value="sec">secondaire</option>
<option value="uni">universitaire/haute ecole</option>
</select>
</td>
</tr>
<tr>
<td><label>Commentaire </label></td>
<td>
<textarea name="com" cols="20" onKeyPress="return valid_mail(event);"><?php if(isset($_POST['com'])){ echo $_POST['com']; } ?>
</textarea>
</td>
</tr>
<tr>
<td><label>Lien </label></td>
<td>
<input name="link" type="text" size="20" onKeypress="return valid_mail(event);" value="<?php if(isset($_POST['link'])){ echo $_POST['link']; } ?>"/>
</td>
</tr>
</table>
<input name="submit" type="submit" value="valider">
</form>
<?php
}
}else{
echo 'veuillez vous connecter';
}
?>

Code

INSERT INTO site_upload VALUES('', '2', 'truc', 'com', 'link', 'theo', 'uni', '', '')

Code

--
-- Structure de la table `site_upload`
--

CREATE TABLE IF NOT EXISTS `site_upload` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`com` text NOT NULL,
`link` varchar(255) NOT NULL,
`kesako` varchar(255) NOT NULL,
`niveau` varchar(255) NOT NULL,
`cpt_dl` int(11) NOT NULL DEFAULT '0',
`cpt_view` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

Code

INSERT INTO site_upload VALUES(NULL, '2', 'truc', 'com', 'link', 'theo', 'uni', '', '')

Code

INSERT INTO site_upload(id_user, name, com, link, kesako, niveau) VALUES('2', 'truc', 'machin', 'lin', 'theo', 'uni')

Code

INSERT INTO site_upload(name, com, link, kesako, niveau) VALUES('truc', 'machin', 'lin', 'theo', 'uni')

Code

INSERT INTO site_upload VALUES(DEFAULT, '2', 'truc', 'com', 'link', 'theo', 'uni', DEFAULT, DEFAULT)

Code

TRUNCATE TABLE site_upload;