naam, beschrijving loop

<?php

require_once 'Singleton.php';

class training_communicatie {

	public $id, $afdeling;
	protected $connect;
	protected $sql;

	public function __construct() {
		$this->connect = Singleton::getconnect();
	}

	public function __destruct() {
		$this->connect = null;
	}

	
	public function select_training() {
		$afdeling_subafdeling = 'SELECT DISTINCT train.training_naam AS Training, train.beschrijving AS Beschrijving, cat.cat_naam AS Categories, typetrain.type_plaatje AS Plaatjes
					  FROM training train
					  JOIN training_cat train_cat ON train_cat.training_id = train.id
					  JOIN categorie cat ON cat.id = train_cat.cat_id
					  JOIN training_type_training trainingtype ON trainingtype.training_id = train.id
					  JOIN type_training typetrain ON typetrain.id = trainingtype.training_type_training_id
					  WHERE cat_naam="Ontwikkeling" ORDER BY train.training_naam
					  ';
		return $resultaat_subafdeling=mysql_query($afdeling_subafdeling);
	}
}

?>

 <?php
      require_once 'class/training_communicatie.php';
      
      $afdeling1 = new training_communicatie();
      
      $alle_afdelingen = $afdeling1->select_training();


      echo '<table border="0" cellspacing="4" cellpadding="4"><tr>';
	  $intRows = 0;
      //foreach($alle_afdelingen as $a) 
	  while($a=mysql_fetch_assoc($alle_afdelingen))
	  {
		 echo "<td>";  
		 $intRows++;
         echo '<td>' . $a['Training'] . '</td>';
		 $location =  $a['Plaatjes'];
         echo '<td>' . $a['Beschrijving'] . '</td>';
         echo "<img src='$location'>";		 
		if(($intRows)%2==0)  
		{  
		echo"</tr>";  
		}  
      }

      echo '</table>';
      ?>