Nu echt hulp nodig

-- Create syntax for TABLE 'services'
CREATE TABLE `services` (
  `service_id` int unsigned NOT NULL AUTO_INCREMENT,
  `service` char(64) DEFAULT NULL,
  PRIMARY KEY (`service_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- Create syntax for TABLE 'users'
CREATE TABLE `users` (
  `user_id` int unsigned NOT NULL AUTO_INCREMENT,
  `username` char(32) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- Create syntax for TABLE 'users_services'
CREATE TABLE `users_services` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `service_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

SELECT u.username, s.service,
IF((SELECT id FROM Users_services WHERE user_id = u.user_id
AND service_id = s.service_id LIMIT 1) IS NULL,'Not found','Found') result FROM users u, services s LIMIT 0, 25

CREATE TABLE `Girls` (
  `ID` int(100) NOT NULL,
  `Nickname` varchar(100) NOT NULL,
  `Fname` varchar(100) NOT NULL,
  `Lname` varchar(100) NOT NULL,
  `IDcard` varchar(100) NOT NULL,
  `Birthday` date NOT NULL,
  `Wphone` varchar(20) NOT NULL,
  `Pphone` varchar(20) NOT NULL,
  `Nationality` varchar(50) NOT NULL,
  `ICEName1` varchar(100) NOT NULL,
  `ICePhone1` varchar(20) NOT NULL,
  `ICEName2` varchar(100) NOT NULL,
  `ICEPhone2` varchar(20) NOT NULL,
  `Password` varchar(50) NOT NULL,
  `keycode` int(10) NOT NULL,
  `Address` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

CREATE TABLE `Services` (
  `ID` int(11) NOT NULL,
  `Services` varchar(50) NOT NULL,
  `Serv_ID` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `Services` (`ID`, `Services`, `Serv_ID`) VALUES
(1, 'Emmer', 1),
(2, 'Schep', 2),
(3, 'Eten', 3),
(4, 'Drank', 4);

-- --------------------------------------------------------

CREATE TABLE `UserServices` (
  `ID` int(11) NOT NULL,
  `User_ID` int(11) NOT NULL,
  `Services_ID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `UserServices` (`ID`, `User_ID`, `Services_ID`) VALUES
(1, 3, 2),
(2, 3, 3),
(3, 4, 2);


ALTER TABLE `Girls`
  ADD PRIMARY KEY (`ID`);

ALTER TABLE `Services`
  ADD PRIMARY KEY (`ID`);

ALTER TABLE `UserServices`
  ADD PRIMARY KEY (`ID`);

ALTER TABLE `Girls`
  MODIFY `ID` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

ALTER TABLE `Services`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

ALTER TABLE `UserServices`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

User_A - 1 - Emmer <= NOT Selected
User_A - 1 - Emmer <= NOT Selected
User_A - 2 - Schep <= Selected
User_A - 2 - Schep <= NOT Selected
User_A - 3 - Drank <= NOT Selected
User_A - 3 - Drank <= Selected
User_A - 4 - Eten <= NOT Selected
User_A - 4 - Eten <= NOT Selected

User_A - 1 - Emmer <= NOT Selected
User_A - 2 - Schep <= Selected
User_A - 3 - Drank <= Selected
User_A - 4 - Eten <= NOT Selected

<?php
                $sql = 'SELECT Girls.Nickname,	UserServices.User_ID, serServices.Services_ID,	Services.ID, Services.Services
		FROM Girls, UserServices, Services 
                WHERE Girls.ID = '.$_SESSION['ID'].' AND UserServices.User_ID = '.$_SESSION['ID'].'';
		$result		= mysqli_query($connect, $sql);
		$data 		= mysqli_fetch_all($result, MYSQLI_ASSOC);
		
		foreach($data as $row) {
			$konijn = $row['ID'];
			$schaap = $row['Nickname'];
			$varken = $row['Services'];
			$gans	= $row['Services_ID'];
			$kuiken	= $row['User_ID'];
		
			$boer = array($konijn, $schaap, $varken, $gans, $kuiken);
			$boer_1 = array($konijn, $varken);
			$stier = array_unique($boer);
			foreach ($stier as $kalf) {
				
				if($kalf == $konijn && $kalf == $gans) {
					echo "<font color='#00FF00' size='2px'><b>".$schaap." - ".$konijn." - ".$varken." <= Selected</b></font><br />";
				}elseif($kalf == $gans) {
					echo "<font color='#FF0000' size='2px'><b>".$schaap." - ".$konijn." - ".$varken." <= NOT Selected</b></font><br />";
				}
			}
		}
?>