Choose group below All Groups Group 1 Group 2 prepare("delete from skrw_accounts where Player_ID = ?"); $del->bindValue(1,$deleteid); $del->execute(); echo '
Record Deleted
'; } if ($group){ $where = ' and skrw_map_group_members.Group_ID = '.$group.' '; } $sql = $dbh->prepare("select skrw_accounts.Player_ID,skrw_accounts.Player_Username,skrw_map_group_members.Group_ID from skrw_accounts,skrw_map_group_members where skrw_accounts.Player_ID = skrw_map_group_members.Player_ID $where"); echo ''; $sql->execute(); while ($row= $sql->fetch()){ $playerid = $row[0]; $uname = $row[1]; $groupid = $row[2]; echo ''; } ///show all players and groups echo '

Username	Group Id
'.$uname.'	'.$groupid.'

'; //add a sort //add a delete button ?>