[ganima]

There seems to be a problem with the field name. I get this MySQL error:
(...) Unknown column 'field7' in 'where clause' (...)

That is the part of my code:

PHP Code:

if ($sortfield == 'nachname') 
            {
                $condition = 'field7 LIKE("' . $db->escape_string_like($ltr) . '%")';
            }
            else
            {    
                $condition = 'username LIKE("' . $db->escape_string_like($ltr) . '%")';
            } 


What's wrong with that? field7 is correct but the field name is not. I also tried to insert a variable like $userinfo[field7].

What is the right syntax here for the field name? Can anybody help?