How to get username by id from mysql database?

Question

MySQL

I'm trying to get the username by id, but as a result I get an Array instead of a name

$user_name = $db->super_query( "SELECT name FROM " . USERPREFIX . "_users WHERE user_id=3 " );
  $user_name = $user_name['name'];

Where is the mistake? Help me fix it please.

Answer 1

$user_name_super_query = $db->super_query( "SELECT name FROM " . USERPREFIX . "_users WHERE user_id=3 " );
$user_name = $user_name_super_query['name'];
echo $user_name; // Тут будет Имя