Bonjour,
j'ai le code php suivant:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
$e1 = mysql_query("SELECT * FROM equipes WHERE nom = '" . $data['domicile'] . "'") or die(mysql_error());
$e2 = mysql_query("SELECT * FROM equipes WHERE nom = '" . $data['visiteur'] . "'") or die(mysql_error());
$e11 = mysql_fetch_array($e1);
$e22 = mysql_fetch_array($e2);
if($data['scoreD'] > $data['scoreE'])
{
$pointsD = $e11['points'] + 3;
$victoireD = $e11['victoire'] + 1;
$defaiteE = $e22['defaite'] + 1;
$matchD = $e11['match'] + 1;
$matchE = $e22['match'] + 1;
$bpD = $e11['bp'] + $data['scoreD'];
$bpE = $e22['bp'] + $data['scoreE'];
$bcD = $e11['bp'] + $data['scoreE'];
$bcE = $e22['bp'] + $data['scoreD'];
$gaDtemp = $data['scoreD'] - $data['scoreE'];
$gaEtemp = $data['scoreE'] - $data['scoreD'];
$gaD = $e11['ga'] + $gaDtemp;
$gaE = $e22['ga'] + $gaEtemp;
mysql_query("UPDATE equipes SET match='" . $matchD . "', victoire='" . $victoireD . "', bp='" . $bpD . "', bc='" . $bcD . "', points='" . $pointsD . "', ga='" . $gaD . "' WHERE nom='" . $e11['nom'] . "'") or die(mysql_error());
mysql_query("UPDATE equipes SET match='" . $matchE . "', defaite='" . $defaiteE . "', bp='" . $bpE . "', bc='" . $bcE . "', ga='" . $gaE . "' WHERE nom='" . $e22['nom'] . "'") or die(mysql_error());
} |
Ce qui pose problème, c'est la requête tout en bas:
mysql_query("UPDATE equipes SET match='" . $matchD . "', victoire='" . $victoireD . "', bp='" . $bpD . "', bc='" . $bcD . "', points='" . $pointsD . "', ga='" . $gaD . "' WHERE nom='" . $e11['nom'] . "'") or die(mysql_error());
Il me vient l' erreur suivante:
Erreur de syntaxe près de 'match='1', victoire='1', bp='3', bc='1', points='3', ga='2' WHER' à la ligne 1
Qqun peut-il m'aider a corriger cette erreur de syntaxe svp?
Merci d'avance
Partager