Probleme erreur SQL

Résolu
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 'WHERE pseudo="test"' at line 1


Voila j'ai cette erreur SQL et voici mon code

if(isset($_POST['pseudo']))
{
$sql2 = 'SELECT COUNT(*) AS nbr WHERE pseudo="'.mysql_real_escape_string($_POST['pseudo']).'"';
$query2 = mysql_query($sql2) or exit(mysql_error());
$donnees2 = mysql_fetch_assoc($query2);
}

2 réponses

  1. Contributeur
    Salut,

    il te manque la table sur laquelle tu travailles.