message d'erreur de syntax
Bonjour à tous
J'ai apparement un problème de syntax, mais je ne le vois pas,
voila le code :
Code:
1 2 3 4 5 6
| if(isset($_POST['ExeSql'])){
$sql = "INSERT INTO msn values (NULL, '".$_POST['cat_tmp']."', '".$_POST['date_tmp']."' , '".$_POST['fichier_tmp']."','".$_POST['image_tmp']."', '".$_POST['pseudo_tmp']."', '".$_POST['email_tmp']."' )";
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$sql3 = "delete from msn_tmp where msn_id = ".$_POST['id_tmp']. "";
$req3 = mysql_query($sql3) or die('Erreur SQL !<br>'.$sql3.'<br>'.mysql_error());;
} |
voila le form :
Code:
1 2 3 4 5 6 7 8 9 10 11
| <form action=index.php method="post" >
<input type="hidden" value="'.$msn['msn_id'].' name="id_tmp">
<input type="hidden" value="'.$msn['msn_cat'].'" name="cat_tmp">
<input type="hidden" value="'.$msn['msn_date'].'" name="date_tmp">
<input type="hidden" value="'.$msn['msn_lien_tel'].'" name="fichier_tmp">
<input type="hidden" value="'.$msn['msn_lien_img'].'" name="image_tmp">
<input type="hidden" value="'.$msn['peusdo'].'" name="pseudo_tmp">
<input type="hidden" value="'.$msn['email'].'" name="email_tmp">
<input type="hidden" value="valider" name="ExeSql">
<input type=submit value="valider"/>
</form> |
Et voila le message :
Citation:
Erreur SQL !
delete from msn_tmp where msn_id =
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 '' at line 1
Je précise que la requete INSERT marche suel le delete ne marche pas.
Merci à tous