<?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')
{

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

    $query = mysql_query("SELECT * FROM patrick WHERE $ff1");
    $result = $query or die();
    $num_rows = mysql_num_rows($result);

    if(($num_rows) == 0) {
        echo "<div>Er is helaas geen artiekel gevonden</div>";
    } else {}

    if($result == false)
    {
        user_error("Query failed: " . mysql_error() . "<br />\n$query");
    } elseif(mysql_num_rows($result) == 0) {
        //echo "<p>Sorry, no rows were returned by your query.</p>\n";
        echo "<p>Probeer een ander selectie, deze selectie heeft geen resulaten opgeleverd.</p>\n";
    } else {
        //while($query_row = mysql_fetch_assoc($result))
        while($row = mysql_fetch_assoc($result))
        {
                //print_r($row);

                echo  $row['onderzoek'];
                echo  $row['informatie'];
                echo  $row['nieuws'];
        }
        //mysql_close($con);
    }
} else {
    echo 'U kunt deze pagina niet bekijken!';
}

?>