Uitlezen in groepen (Opgelost)

CREATE TABLE `links` (
  `id` int(10) NOT NULL auto_increment,
  `naam` varchar(100) NOT NULL,
  `image` varchar(100) default NULL,
  `website` varchar(100) NOT NULL,
  `sitetaal` enum('Nederlands','Engels','Duits','Pools') NOT NULL,
  `clicksin` int(50) default NULL,
  `clicksout` int(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT

CREATE TABLE `links` (
  `id` int(10) NOT NULL auto_increment,
  `naam` varchar(100) NOT NULL,
  `image` varchar(100) default NULL,
  `website` varchar(100) NOT NULL,
  `sitetaal` enum('Nederlands','Engels','Duits','Pools') NOT NULL,
  `clicksin` int(50) default NULL,
  `clicksout` int(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT

<?php
$query = "SELECT * FROM links WHERE sitetaal = 'Nederlands'";
?>

<?php
$query = "SELECT * FROM links WHERE sitetaal = 'Nederlands'";
?>

while()
{
if(dezetaal != taal_van_de_vorige)
echo '</tr><tr><td>nieuwe_taal</td></tr><tr>';

echo 
}

while()
{
if(dezetaal != taal_van_de_vorige)
echo '</tr><tr><td>nieuwe_taal</td></tr><tr>';
 
echo 
}

<?
include "config.php";

		$selectcat = mysql_query("SELECT * FROM links_cat ORDER BY id ASC") or die (mysql_error());
		while($arrcat = mysql_fetch_assoc($selectcat)){
		$catid = $arrcat['id'];
		$catnaam = $arrcat['naam'];
?>		
	<table>
		<tr>
			<td><strong><?=$catnaam;?></strong></td>
		</tr><br/>

<?

			$select = mysql_query("SELECT * FROM links WHERE sitetaal = '".$catid."'") or die (mysql_error());
			while($arr = mysql_fetch_assoc($select)){
				$id = $arr['id'];
				$naam = $arr['naam'];
				$website = $arr['website'];
?>
		<tr>
			<td><a href="Linkpartner/clickout.php?id=<?=$id;?>"><?=$naam;?></a></td>
		</tr>
		<?
		}
		}
		?>
</table>

<?
include "config.php";
 
		$selectcat = mysql_query("SELECT * FROM links_cat ORDER BY id ASC") or die (mysql_error());
		while($arrcat = mysql_fetch_assoc($selectcat)){
		$catid = $arrcat['id'];
		$catnaam = $arrcat['naam'];
?>		
	<table>
		<tr>
			<td><strong><?=$catnaam;?></strong></td>
		</tr><br/>
 
<?
 
			$select = mysql_query("SELECT * FROM links WHERE sitetaal = '".$catid."'") or die (mysql_error());
			while($arr = mysql_fetch_assoc($select)){
				$id = $arr['id'];
				$naam = $arr['naam'];
				$website = $arr['website'];
?>
		<tr>
			<td><a href="Linkpartner/clickout.php?id=<?=$id;?>"><?=$naam;?></a></td>
		</tr>
		<?
		}
		}
		?>
</table>