Mural de recados

< ?php
    $server ="localhost";
    $user="root";
    $password="";
    $dbname="mural_de_recados";
    mysql_connect($server,$user,$password) or die(mysql_error());
    mysql_select_db($dbname) or die(mysql_error());
? >

< ?php
    $server ="localhost";
    $user="root";
    $password="";
    $dbname="mural_de_recados";
    mysql_connect($server,$user,$password) or die(mysql_error());
    $query= "CREATE DATABASE mural_de_recados";
    mysql_query($query) or die (mysql_error());
?>

<!--p<br-->   include("conecta.php");
   $query = "CREATE TABLE recados
                (id int NOT NULL AUTO_INCREMENT,
                 titulo varchar(256),
                 comentario text,
                 email varchar(256),
                 PRIMARY KEY(id))";
   mysql_query($query) or die(mysql_error());
   mysql_close();                                      
? >

< html>
    < head>
        < title>Mural de Recados em PHP
    < /head>
    < body>
        < h1>Mural de Recados< /h1>
        < form method="POST" action="cadastra.php">
            Titulo: < input type="text" name="titulo" />


            E-mail: < input type="text" name="email" />

           
            Recado: < textarea name="recado">Deixe seu recado!< /textarea>

            < input type="submit" />
           
           
            < h2>Recados Postados: < /h2>
            < ?php
                include("conecta.php");               
                $query = "SELECT * FROM recados ORDER BY id DESC";
                $resultado = mysql_query($query) or die(mysql_error());
                while ($row = mysql_fetch_array($resultado)) {
                    echo "< b>".$row["titulo"]."< /b>";
                    echo "< br/>";
                    echo $row["comentario"];
                    echo "< br/>";               
                    echo "E-mail: < b>".$row["email"]."< /b>";
                    echo "< br/>< br/>";                               
                }
                mysql_close();
            ? >
        < /form>
    < /body>
< /html>

< ?php
    include("conecta.php");
    $titulo = $_POST['titulo'];
    $email = $_POST['email'];
    $recado = $_POST['recado'];
   
   
    $query = "INSERT INTO recados (titulo,email,comentario) VALUES ('$titulo','$email','$recado')";
    mysql_query($query) or die (mysql_error());
   
    mysql_close();
   
    header("location:index.php")
? >