[SQL] erreur sur requête insert
Erreur SQL ! : 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 'WHERE IDJ='1'' at line 2
Requête utilisée : INSERT INTO prono (match1,match2,match3,match4,match5,match6,match7,match8) VALUES ('0-0','0-0','0-0','0-0','0-0','0-0','0-0','0-0') WHERE IDJ='1'
Code:
1
2
3
4
5
|
$lol=1;
$sql = "INSERT INTO prono (match1,match2,match3,match4,match5,match6,match7,match8)
VALUES ('$match1','$match2','$match3','$match4','$match5','$match6','$match7','$match8') WHERE IDJ='$lol'";
mysql_query($sql) or die ("Erreur SQL ! : ".mysql_error()."<br />Requête utilisée : ".$sql); |
