hello, i am working on my personal website wih php 5.4.16 / mysql 5.6.12 (my
system : windows 7 / wampserver 2).
i have a bug when i am running my connection to database webpage.
My error message is the following :
Erreur SQL : 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 ''membres2' WHERE
'pseudo_membre' = '\'Flarose59\'' GROUP BY
'id_membre'' at line 1
Ligne : 29.
this is my php code :
$result = sqlquery("SELECT COUNT('id_membre') AS nbr, 'id_membre',
'pseudo_membre', 'mdp_membre' FROM 'espace_membre2'.'membres2' WHERE
'pseudo_membre' = '\'".mysql_real_escape_string($_POST['pseudo'])."\'' GROUP BY
'id_membre'", 1);
I tried several delimitator for the query function (like ' \* ').