bonjour tout le monde, voici mon formulaire :
<h4>Accès aux pages :</h4>
<form action="autorisation_pages.php" method="post">
<p>Pseudo : <input type="text" name="id_pseudo"/>
<input type="checkbox" id="page1" name="page1" value="ok"/><label for="page1">page1</label>
<input type="checkbox" id="page2" name="page2" value="ok"/><label for="page2">page2</label>
<input type="checkbox" id="page3" name="page3" value="ok"/><label for="page3">page3</label>
<input type="checkbox" id="page4" name="page4" value="ok"/><label for="page4">page4</label>
<input type="checkbox" id="page5" name="page5" value="ok"/><label for="page5">page5</label>
<input type="checkbox" id="page6" name="page6" value="ok"/><label for="page6">page6</label>
<input type="checkbox" id="page7" name="page7" value="ok"/><label for="page7">page7</label>
<input type="checkbox" id="page8" name="page8" value="ok"/><label for="page8">page8</label></p>
<input type="submit" value="Valider"/>
</form>
et voici ma page de gestion du résultat :
$pseudo = $_POST['id_pseudo'];
$page1 = $_POST['page1'];
$page2 = $_POST['page2'];
$page3 = $_POST['page3'];
$page4 = $_POST['page4'];
$page5 = $_POST['page5'];
$page6 = $_POST['page6'];
$page7 = $_POST['page7'];
$page8 = $_POST['page8'];
mysql_connect('','','') or die(mysql_error());
mysql_select_db('') or die(mysql_error());
mysql_query("UPDATE membres SET page1='$page1', page2='$page2, page3='$page3', page4='$page4', page5='$page5', page6='$page6', page7='$page7', page8='$page8' WHERE pseudo='$pseudo'") or die(mysql_error());
Je voudrai savoir pourquoi j'ai ce message d'erreur et comment résoudre le problème :
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 'administrateur'' at line 1
Merci d'avance et A++
Si t'a besoin d'aide, MP !!!
