Nicketick

Untitled

Feb 27th, 2012
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.32 KB | None | 0 0
  1. <table width="100%" style="text-align: left;">
  2. <tr><th>Datum</th><th>Tijd</th><th>Lokaal</th><th>Vak</th><th>Docent</th><th>Opmerkingen</th></tr>
  3. <?php
  4. include("config.inc.php");
  5.  
  6. // initialization
  7. $toetsen = "";
  8. $counter = 0;
  9.  
  10. // Le array
  11. $toetsenar = $_POST['selector'];
  12.  
  13. while( $counter <= count($toetsenar) )
  14. {
  15.  
  16.     $query = mysql_query( "SELECT id, docent, vak, lokaal, datum, richting, opmerkingen FROM toetsrooster WHERE id='$toetsenar'" );
  17.     while($row = mysql_fetch_array($query))
  18.     {
  19.         $docenttoe = mysql_query("SELECT * FROM docent WHERE docent_id='".$row[1]."' ");
  20.         while($doc = mysql_fetch_assoc($docenttoe))
  21.         {
  22.             $docentval = $doc[docent_naam];
  23.         }
  24.         $vaktoe = mysql_query("SELECT * FROM vak WHERE vak_id='".$row[2]."' ");
  25.         while($vakm = mysql_fetch_assoc($vaktoe))
  26.         {
  27.             $vakval = $vakm[vak_naam];
  28.         }
  29.         $lokaaltoe = mysql_query("SELECT * FROM lokaal WHERE lokaal_id='".$row[3]."' ");
  30.         while($lokm = mysql_fetch_assoc($lokaaltoe))
  31.         {
  32.             $lokval = $lokm[lokaal_naam];
  33.         }
  34.         $richtingtoe = mysql_query("SELECT * FROM stroming WHERE stroming_id='".$row[6]."' ");
  35.         while($ricm = mysql_fetch_assoc($richtingtoe))
  36.         {
  37.             $ricval = $ricm[stroming_naam];
  38.         }
  39.         echo ('<tr><td>$row[4]</td><td>$row[5]</td><td>$lokval</td><td>$vakval</td><td>$docval</td><td>$row[7]</td></tr>');
  40.  
  41.  
  42.     }
  43.     mysql_free_result( $query );
  44.     $counter++;
  45.  
  46. }
  47. ?>
  48. </table>
Advertisement
Add Comment
Please, Sign In to add comment