<?php
ini_set('display_errors', 'On');
error_reporting(E_ALL);


$default_sort = 'resultaat4';
$allowed_order = array ('resultaat1', 'resultaat2', 'resultaat3', 'resultaat4', 'resultaat5', 'resultaat6', 'resultaat7', 'resultaat8');
 
if (isset($_POST['submit'])) {
    if ($_POST['leeftijd'] == "") {
        echo "<b>Fout: Leeftijd is niet ingevuld</b>";
    } else {
    }
}


if (!isset ($_GET['order']) || 
    !in_array ($_GET['order'], $allowed_order)) {
    $order = $default_sort;
} else {
    $order = $_GET['order'];
}
 
mysql_connect("localhost","",""); //(host, gebruikersnaam, wachtwoord)
 
mysql_select_db("") or die("Unable to select database"); //database
 
$query="SELECT * FROM vergelijk ORDER BY $order DESC LIMIT 2";
$result=mysql_query($query) or die(mysql_error());
if($result) {
//niks
}
else {
echo"Geen resultaten gevonden";//foutmelding
}
 
 
$num=mysql_numrows($result);
 
mysql_close();
 
echo "<b><center>Resultaten</center></b><br><br>";
 
$i=0;
while ($i < $num) {
 
$resultaat1=mysql_result($result,$i,"resultaat1");
$resultaat2=mysql_result($result,$i,"resultaat2");
$resultaat3=mysql_result($result,$i,"resultaat3");
$resultaat4=mysql_result($result,$i,"resultaat4");
$resultaat5=mysql_result($result,$i,"resultaat5");
$resultaat6=mysql_result($result,$i,"resultaat6");
$resultaat7=mysql_result($result,$i,"resultaat7");
$resultaat8=mysql_result($result,$i,"resultaat8");
$resultaat9=mysql_result($result,$i,"resultaat9");
$resultaat10=mysql_result($result,$i,"resultaat10");
$resultaat11=mysql_result($result,$i,"resultaat11");
$resultaat12=mysql_result($result,$i,"resultaat12");
 
echo ''.$resultaat1.'<br><img src=/images/resultaat/'.$logo.' width=200 height=120 border=0><br>resultaat2: <img src=/images/resultaat2/'.$resultaat2.' border=0><br>resultaat3: '.$resultaat3.'<br>resultaat4: '.$resultaat4.'<br>'.$resultaat5.'<br>'.$resultaat7.'<br><a href=/pdf/'.$resultaat8.'>resultaat8</a><hr><br>';
 
$i++;
}
  ?>