Nicketick

Untitled

Feb 27th, 2012
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.35 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. $toetsen .=<<<__HTML_END
  40. <tr><td>$row[4]</td><td>$row[5]</td><td>$lokval</td><td>$vakval</td><td>$docval</td><td>$row[7]</td></tr>
  41. __HTML_END;
  42.    
  43.     }      
  44.         mysql_free_result( $query );
  45.     $counter++;
  46.    
  47.     }
  48.  
  49.     // Print Result
  50. echo "$toetsen";
  51.  
  52. ?>
  53. </table>
Advertisement
Add Comment
Please, Sign In to add comment