pagination met join tables

require_once 'Singleton.php';

class alle_trainingen {

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

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

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

	
	public function select_trainingen() {
		$all_categorie = 'SELECT DISTINCT train.naam_training AS Training, train.beschrijving AS Beschrijving, cat.naam_categorie AS Categorie, typetrain.type_naam AS Type, typetrain.type_plaatje AS Plaatjes
					  FROM training train
					  JOIN training_categorie train_cat ON train_cat.training_id = train.id
					  JOIN categorie cat ON cat.id = train_cat.categorie_id
					  JOIN training_type trainingtype ON trainingtype.training_id = train.id
					  JOIN type_training typetrain ON typetrain.id = trainingtype.type_id
					  ORDER BY train.naam_training
					  ';
		return $resultaat_all_categorie=mysql_query($all_categorie);
	}
}

<?php
include_once "structuur/header.html";
?>
<div id="container">
<div id="left-container"> 
<?php
include_once "structuur/sidebar_soort_training_menu.html";
?>    
</div>
<div id="right-container2">
 
    <h6>Alle trainingen op alfabetische volgorde</h6>
      <?php
      require_once 'class/all_training_categorie.php';
      
      $soort_training = new alle_trainingen();
      
      $alle_training_soort = $soort_training->select_trainingen();
 
	  while($a=mysql_fetch_assoc($alle_training_soort))
	  {      
		 echo "<div id='container'><td>";  
         echo "<div id='left3'>";        
         echo '<td><b>' . $a['Training'] . '</b></td><br>';
		 $plaatje =  $a['Plaatjes'];
         echo '<td>' . $a['Beschrijving'] . '</td><br>';   
         echo '<br>';
		 echo '<td>Categorie: <b>' . $a['Categorie'] . '</b></td><br>';
		 echo "</div>";  
         echo "<div id='right5'>"; 
         echo "<div class='overzicht-plaatje'> <img src='$plaatje'/> </div> <br>" ;
	
		{
        echo "</div>";  
		echo"</tr></div>";  
		}  
      }

      ?>