J'essaye désespérément d'effectuer un update sur une table, mais celui-ci ne fonctionne pas.
Voilà ce qu'il m'indique :
CODE
Erreur SQL ! UPDATE base SET src_id_fam = '2', src_id_genre = '8', src_id_spec = '1', actif = 'on', temp = '5', valid = 'on', syn = '', desc = 'desc' WHERE id_base = 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 'desc = 'desc' WHERE id_base = 1' at line 3
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 'desc = 'desc' WHERE id_base = 1' at line 3
Si j'enlève la partie desc='desc', l'update fonctionne...
Structure de ma table :
CODE
CREATE TABLE base (
id_base int(11) NOT NULL auto_increment,
src_id_fam int(11) NOT NULL,
src_id_genre int(11) NOT NULL,
src_id_spec int(11) NOT NULL,
src_id_member int(11) NOT NULL,
syn varchar(255) collate latin1_general_ci NOT NULL,
actif char(3) collate latin1_general_ci NOT NULL,
temp int(11) NOT NULL,
`desc` longtext collate latin1_general_ci NOT NULL,
origine varchar(255) collate latin1_general_ci NOT NULL,
url_photo1 varchar(255) collate latin1_general_ci NOT NULL,
url_photo2 varchar(255) collate latin1_general_ci NOT NULL,
url_photo3 varchar(255) collate latin1_general_ci NOT NULL,
date_ajout datetime NOT NULL,
valid char(3) collate latin1_general_ci NOT NULL,
PRIMARY KEY (id_base)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
id_base int(11) NOT NULL auto_increment,
src_id_fam int(11) NOT NULL,
src_id_genre int(11) NOT NULL,
src_id_spec int(11) NOT NULL,
src_id_member int(11) NOT NULL,
syn varchar(255) collate latin1_general_ci NOT NULL,
actif char(3) collate latin1_general_ci NOT NULL,
temp int(11) NOT NULL,
`desc` longtext collate latin1_general_ci NOT NULL,
origine varchar(255) collate latin1_general_ci NOT NULL,
url_photo1 varchar(255) collate latin1_general_ci NOT NULL,
url_photo2 varchar(255) collate latin1_general_ci NOT NULL,
url_photo3 varchar(255) collate latin1_general_ci NOT NULL,
date_ajout datetime NOT NULL,
valid char(3) collate latin1_general_ci NOT NULL,
PRIMARY KEY (id_base)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Code de ma requête :
CODE
$sql="UPDATE base
SET src_id_fam = '$famille', src_id_genre = '$genre', src_id_spec = '$espece', actif = '$actif',
temp = '$temp', valid = '$valid', syn = '$syn'
WHERE id_base = $spec";
mysql_query($sql) or die("<b>Erreur SQL !</b> ".$sql."<br>".mysql_error());
SET src_id_fam = '$famille', src_id_genre = '$genre', src_id_spec = '$espece', actif = '$actif',
temp = '$temp', valid = '$valid', syn = '$syn'
WHERE id_base = $spec";
mysql_query($sql) or die("<b>Erreur SQL !</b> ".$sql."<br>".mysql_error());
Je n'y comprends plus rien..
Merci de votre aide
