php - Register a generated uniqid in database -

today need help. i'm coding register form , each new registration generate key uniqid() function.

the problem when try insert generated key in database i've error:

erreur: sqlstate[42000]: syntax error or access violation: 1064 have error in sql syntax; check manual corresponds mysql server version right syntax use near 'key) values('','test','test','test@test.com','7c4a8d09ca3762af61e59520943dc26494' @ line 1

the field key in database set varchar(90).

i've looked answer on google or here i haven't found same issue.

does knows problem please ?

thks, antho

edit:

here sql request:

$key = uniqid();  try{     $sql = "insert users(id,name,firstname,mail,pass,status,avatar,key) values('','$name','$firstname','$mail','$pass','$status','$avatar','$key')";     $req = $db->exec($sql);      echo 'ok'; }catch(pdoexception $e){     echo 'erreur: '.$e->getmessage(); } 

i believe key mysql reserved word. try escaping

`key`