<?php
    $dbhost = 'localhost';
    $dbuser = 'dbuser ';
    $dbpass = 'dbpass ';
    $dbname = 'dbname';

    $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Errorconnecting to mysql');
    mysql_select_db($dbname);

if($_SERVER['REQUEST_METHOD'] == 'POST')
{
    $filter1 = strtolower($_POST['geslacht']);
    if($filter1=="man")
    {
        $ff1    = 'geslacht="man"';
    } elseif($filter1=="vrouw") {
        $ff1    = 'geslacht="vrouw"';
    } else {
        $ff1    = "";
    }
}else{
    echo 'leeg';
}

if($_SERVER['REQUEST_METHOD'] == 'POST')
{
    $filter3 = strtolower($_POST['provincie']);
    if($filter3=="overijsel"){
        $ff3    = 'provincie="overijsel"';
    } elseif($filter3=="noordholland") {
        $ff3    = 'provincie="noordholland"';
    } elseif($filter3=="braband") {
        $ff3    = 'provincie="braband"';
    } elseif($filter3=="friesland") {
        $ff3    = 'provincie="friesland"';
    } elseif($filter3=="zuidholland") {
        $ff3    = 'provincie="zuidholland"';
    } elseif($filter3=="gelderland") {
        $ff3    = 'provincie="gelderland"';
    } else {
        $ff3    = "";
    }
}else{
    echo 'leeg';
}

if(ctype_digit($_POST['leeftijd'])) {
    $ff2 = 'leeftijd "'.mysql_real_escape_string($_POST['leeftijd']).'"';
} else {
    $ff2 = '';
}

if(ctype_digit($_POST['kinderen'])) {
    $ff4 = 'kinderen "'.mysql_real_escape_string($_POST['kinderen']).'"';
} else {
    $ff4 = '';
}



$query = mysql_query("SELECT * FROM patrick WHERE geslacht = '$ff1' AND leeftijd = '$ff2' AND provincie = '$ff3' AND kinderen = '$ff4'");
//$result = mysql_query($query);

$result = $query or die();
//$result = mysql_query($query);
if($result == false)
{
   user_error("Query failed: " . mysql_error() . "<br />\n$query");
}
else if(mysql_num_rows($result) == 0)
{
   echo "<p>Sorry, no rows were returned by your query.</p>\n";
}
else
{
   while($query_row = mysql_fetch_assoc($result))
   {
      foreach($query_row as $row)
      {
         echo $row['beschrijving'];
         echo $row->beschrijving;
         echo $row;
      }
      echo "<br />\n";
   }
}


?>