Untitled

<?php

function errors_rep($er) {  //Print errors function
    foreach ($er as $id => $val) {
        if (isset($val) && !empty($val)){
            echo "ERROR_ID:".$id."<br>".$val."<br>";
        }
    }
}

unset($errors);
$link = mysql_connect('localhost', 'root', 'root');
$db_selected = mysql_select_db('book', $link);
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    if ($_POST['agreement'] == TRUE)    {
        if (strlen($_POST['username']) > 4) {
            if ($link) {
                $res = "INSERT INTO `messages`
                (`name`, `text`, `from_id`, `gender_id`)
                VALUES
                ('{$_POST['username']}', '{$_POST['message']}', ";
                $sql = "SELECT * FROM `gender` WHERE name='{$_POST['gender']}'";
                $qry = mysql_query($sql);
                while ($gender = mysql_fetch_assoc($qry)) {
                    $res .=$gender["id"].", ";
                }
                $sql = "SELECT * FROM `from` WHERE name='{$_POST['answer']}'";
                $qry = mysql_query($sql);
                while ($from = mysql_fetch_assoc($qry)) {
                    $res .= $from["id"].")";
                }
                $qry = mysql_query($res);
            }
            else $errors[3] = "Data file are not available"."<br>";
        //  header("Location: ".$_SERVER['PHP_SELF']);
        }
        else {
            $errors[2] = "Your nickname must be from 5 simbols"."<br>";;
        }
    }
    else {
    $errors[1] = "If you don't agree with terms and conditions, you will be servå on the firing line"."<br>";
    }
}
?>
<html>
    <head>
        <title>Guest Book</title>
    </head>
    <body>
    <form name="info" method="post">
        <p>Name:<br><input type="text" name="username" maxlength="15" size="90"></p>
        <p>Gender <select size="1" name="gender">
            <option value="male">Male</option>
            <option value="female">Female</option>
        </select></p>
        <p>Message:<br><textarea rows="10" cols="115" name="message"></textarea></p>
        You come from:
        <div>
            <input type="radio" name="answer" value="google">Google<Br/>
            <input type="radio" name="answer" value="facebook">Facebook<Br/>
            <input type="radio" name="answer" value="twitter">Twitter<Br/>
            <input type="radio" name="answer" value="Yahoo">Yahoo<Br/>
        </div>
        <br/>
        <div>
            <input type="checkbox" name="agreement" >I agree with terms and conditions</div>
            <div>
                <input type="submit" value="Submit" >
            </div>
        </div>
<?php
$sql = "SELECT * FROM `messages` LIMIT 0, 20";
$qry = mysql_query($sql);
while ($row = mysql_fetch_assoc($qry)){
    $res = "ID:".$row["id"]." Name:".$row["name"]. " Text:".$row["text"]." Gender:";
    $sql_n = "SELECT * FROM `gender` WHERE id='{$row["gender_id"]}'";
    $qry_n = mysql_query($sql_n);
    while ($g = mysql_fetch_assoc($qry_n)) {
        $res .= $g["name"];
    }
    $sql_n = "SELECT * FROM `from` WHERE id='{$row["from_id"]}'";
    $qry_n = mysql_query($sql_n);
    while ($fr = mysql_fetch_assoc($qry_n)) {
        $res .= " FROM:".$fr["name"];
    }
    echo $res."<br>";
}

errors_rep($errors);
?>
    </body>
</html>