re

alors lors de la mise a jour j'ai ce message d'erreur

Erreur SQL !
UPDATE Classe SET Nb = '0'1 WHERE Id = '1'
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 '1 WHERE Id = '1'' at line 1

voici le code de la page mise a jour


<?php

if(isset($_POST['nb'])) $Nb=$_POST['nb'];
else $Nb="";

// on se connecte à MySQL
$db = mysql_connect('sql3', 'lyceebai', 'p8ybx63r');

// on seléctionne la base
mysql_select_db('lyceebai',$db);

// on crée la requete SQL

for($i=1; $i<22;$i++){
$sql = "UPDATE Classe SET Nb = '$nb'".$i." WHERE Id = '$i'";

$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
}
?>