i am using php 8 & PDO but i am trying to select enum from the database for friends and enemys list and im not getting an error but i can only get it to say that i am friends with them so it just says remove friends i have tried several different things to get it to select if your friends or enemys but it will not let me do it here is my code
$db->query('SELECT type, user, person FROM lists WHERE user = ? AND person = ?');
$db->execute([$i['userid'], $u['userid']]);
$row = $db->fetch_row();
if(!$row) {
$fri = '<a href="friends?add='.$profile_info->name.'">Add friend</a>';
$ene = '<a href="enemys?add='.$profile_info->name.'">Add enemy</a>';
} else {
if($row['type'] = 'friend') {
$fri = 'remove friend';
$ene = '';
} else if($row['type'] = 'enemy') {
$fri = '';
$ene = 'Remove enemy';
}
}