Je sais pas si je deviens fous mais....
ma requête avec le php... :
$nombre_remarques = mysql_query('SELECT for, num_com FROM commentaires_com WHERE for="par" AND num_com="41275"') or die( 'Erreur MySQL nb rem : <br />'.mysql_error() );
$nombre_remarques_final = mysql_num_rows($nombre_remarques);
si je fais :
echo 'SELECT for, num_com FROM commentaires_com WHERE for="par" AND num_com="41275"';
j'obtient :
L'erreur MySQL :SELECT for, num_com FROM commentaires_com WHERE for="par" AND num_com="41275"
Structure de la table commentaires_com :Erreur MySQL nb rem :
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 'for, num_com FROM commentaires_com WHERE for="par" AND num_com="41275"' at line 1
Merci à vous !CREATE TABLE `commentaires_com` (
`id` int(3) NOT NULL auto_increment,
`for` varchar(10) NOT NULL,
`valide` int(1) NOT NULL default '0',
`num_com` varchar(10) NOT NULL,
`commentaire` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB ;