MySQL: Unknown column 'user' in 'where clause'

[shmia]

Delphi-Quellcode:

  // falsch
  q.SQL.Text := 'SELECT * ' + 
                'FROM `' + ini.ReadString('mysql', 'db_table_users', '') + '` ' + 
                'WHERE `nick` = ' + nick + ';'; 

  // richtig
  q.SQL.Text := 'SELECT * ' + 
                'FROM ' + ini.ReadString('mysql', 'db_table_users', '') + ' ' + 
                'WHERE nick=' + QuotedStr(nick); 
  // noch besser wäre die Benutzung von Parametern
  q.SQL.Text := 'SELECT * ' + 
                'FROM ' + ini.ReadString('mysql', 'db_table_users', '') + ' ' + 
                'WHERE nick=:nick'; 
  q.paramValues['nick'] := nick;
  q.Open;