<?php
$db_host="localhost";
$db_user="root";
$db_pass="";
$db_name="site";
$tbl_name="pages";

$conn = mysql_connect($db_host, $db_user, $db_pass);
if(!$conn) die("Could not connect to server<br />".mysql_error());
mysql_select_db($db_name)or die("cannot select DB<br />".mysql_error());

if (!isset($view)) {
    if (empty($_GET['page'])) {
        $view = 'main';
    } else {
        $view = $_GET['page'];
        if ($view != 'main' && $view != 'about' && $view != 'contact' && $view != 'services' && $view != 'suppliers') {
            $view = 'main';
        } else {
            $view = $_GET['page'];
        }
    }
}

$query = "SELECT name,content FROM $tbl_name WHERE name = '$view'";
$result = mysql_query($query);

if ($result) {
    $row = mysql_fetch_row($result);
    $title = $row[0];
    $body = $row[1];

    mysql_free_result($result);
}

?>