Ingewikkelde vraag

WHERE id=$aCompetities[$i];

WHERE id=$aCompetities[$i];

CREATE TABLE competities (
id INT(11) NOT NULL auto_increment,
naam VARCHAR(255) NOT NULL,
PRIMARY KEY(id)
);

CREATE TABLE competities (
id INT(11) NOT NULL auto_increment,
naam VARCHAR(255) NOT NULL,
PRIMARY KEY(id)
);

CREATE TABLE spelers (
id INT(11) NOT NULL auto_increment,
naam VARCHAR(255) NOT NULL,
competities (VARCHAR(255) NOT NULL,
PRIMARY KEY(id)
);

CREATE TABLE spelers (
id INT(11) NOT NULL auto_increment,
naam VARCHAR(255) NOT NULL,
competities (VARCHAR(255) NOT NULL,
PRIMARY KEY(id)
);

<?PHP
$sQuerySpelers = "SELECT * FROM spelers ORDER BY naam ASC";
if(!$rResultSpelers = MySQL_Query($sQuerySpelers))
{
	echo "Error!- ".MySQL_Error()."<br />".MySQL_Errno()."<br />In file: ".__FILE__."<br />Op lijn: ".__LINE__."<br />".$sQuerySpelers;
} else
{
	while($aFetchSpelers = MySQL_Fetch_Assoc($rResultSpelers))
	{
		echo $aFetchSpelers['naam']." speelt in de volgende competities:<br />";
		$aCompetities = explode(",", $aFetchSpelers['competities']);
		for($i = 0; $i < count($aCompetities); $i++)
		{
			$sQueryCompetities = "SELECT * FROM competities WHERE id=".$aCompetities[$i];
			if(!$rResultCompetities = MySQL_Query($sQueryCompetities))
			{
				echo "Error!- ".MySQL_Error()."<br />".MySQL_Errno()."<br />In file: ".__FILE__."<br />Op lijn: ".__LINE__."<br />".$sQueryCompetities;
			} else
			{
				echo MySQL_Result($rResultCompetities, 0, "naam");
			}
		}
	}
}
?>

<?PHP
$sQuerySpelers = "SELECT * FROM spelers ORDER BY naam ASC";
if(!$rResultSpelers = MySQL_Query($sQuerySpelers))
{
	echo "Error!- ".MySQL_Error()."<br />".MySQL_Errno()."<br />In file: ".__FILE__."<br />Op lijn: ".__LINE__."<br />".$sQuerySpelers;
} else
{
	while($aFetchSpelers = MySQL_Fetch_Assoc($rResultSpelers))
	{
		echo $aFetchSpelers['naam']." speelt in de volgende competities:<br />";
		$aCompetities = explode(",", $aFetchSpelers['competities']);
		for($i = 0; $i < count($aCompetities); $i++)
		{
			$sQueryCompetities = "SELECT * FROM competities WHERE id=".$aCompetities[$i];
			if(!$rResultCompetities = MySQL_Query($sQueryCompetities))
			{
				echo "Error!- ".MySQL_Error()."<br />".MySQL_Errno()."<br />In file: ".__FILE__."<br />Op lijn: ".__LINE__."<br />".$sQueryCompetities;
			} else
			{
				echo MySQL_Result($rResultCompetities, 0, "naam");
			}
		}
	}
}
?>