Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <table width="100%" style="text-align: left;">
- <tr><th>Datum</th><th>Tijd</th><th>Lokaal</th><th>Vak</th><th>Docent</th><th>Opmerkingen</th></tr>
- <?php
- include("config.inc.php");
- // initialization
- $toetsen = "";
- $counter = 0;
- // Le array
- $toetsenar = $_POST['selector'];
- while( $counter <= count($toetsenar) )
- {
- $query = mysql_query( "SELECT id, docent, vak, lokaal, datum, richting, opmerkingen FROM toetsrooster WHERE id='$toetsenar'" );
- while($row = mysql_fetch_array($query))
- {
- $docenttoe = mysql_query("SELECT * FROM docent WHERE docent_id='".$row[1]."' ");
- while($doc = mysql_fetch_assoc($docenttoe))
- {
- $docentval = $doc[docent_naam];
- }
- $vaktoe = mysql_query("SELECT * FROM vak WHERE vak_id='".$row[2]."' ");
- while($vakm = mysql_fetch_assoc($vaktoe))
- {
- $vakval = $vakm[vak_naam];
- }
- $lokaaltoe = mysql_query("SELECT * FROM lokaal WHERE lokaal_id='".$row[3]."' ");
- while($lokm = mysql_fetch_assoc($lokaaltoe))
- {
- $lokval = $lokm[lokaal_naam];
- }
- $richtingtoe = mysql_query("SELECT * FROM stroming WHERE stroming_id='".$row[6]."' ");
- while($ricm = mysql_fetch_assoc($richtingtoe))
- {
- $ricval = $ricm[stroming_naam];
- }
- $toetsen .=<<<__HTML_END
- <tr><td>$row[4]</td><td>$row[5]</td><td>$lokval</td><td>$vakval</td><td>$docval</td><td>$row[7]</td></tr>
- __HTML_END;
- }
- mysql_free_result( $query );
- $counter++;
- }
- // Print Result
- echo "$toetsen";
- ?>
- </table>
Advertisement
Add Comment
Please, Sign In to add comment