Function not returning expected value

Can anyone please tell me why this function is returning the user_id as contained in the $friends variable, instead of the first_name and last_name?


public function getFriendsById($friends) {
$sql="SELECT first_name, last_name FROM users WHERE user_id =". $friends;
$results = mysql_query($sql)or die("Selection Query Failed !!!");
$friendsNames = array();
while ($row = mysql_fetch_array($results)){
$friendsNames[] = $row['first_name, last_name'];
}
return $friendsNames;
}

}

Can anyone please tell me why this function is returning the user_id as contained in the $friends variable, instead of the first_name and last_name?


$friendsNames[] = $row['first_name, last_name'];


You can't do that. The best you can do is this:


$friendsNames[] = "$row[first_name], $row[last_name]";

//OR
$friendsNames[] = $row['first_name'] .', ' .$Row['last_name'];

Thanx for your reply.

changed it using your code.

no change

In that case you need to run the SQL statement in phpmyadmin in the SQL page and see what happens.