Untitled

if (isset($_POST['username']) && isset($_POST['email'])) {

$query = $pdo->prepare('INSERT INTO users (name, email, joined) VALUES (?, ?, ?)') or die ('Error.');
$query->bindValue(1, $_POST['username']);
$query->bindValue(2, $_POST['email']);
$query->bindValue(3, time());

$query->execute();

$sql = mysql_query('SELECT * FROM users;');

while ($row = mysql_fetch_array($sql)) {

    echo ('<div style="font-weight: bold;">' .$row['name']. '</div>');
    echo ($row['email']);
    echo ('<br>');
    echo ('Posted: ');
    echo date('F j, Y, g:i a', strtotime($row['joined']));

}

}

<body>
<?php

$query = mysql_query('SELECT * FROM posts;');

while ($row = mysql_fetch_array($query)) {

    echo ('<div style="font-weight: bold;">' .$row['title']. '</div>');
    echo ($row['post']);
    echo ('<br>');
    echo ('Posted: ');
    echo date('F j, Y, g:i a', strtotime($row['date']));

}

?>
</body>

// PDO
$pdo = new PDO('mysql:dbname=test;host=127.0.0.1', 'example', 'example');

print '<h3>PDO: simple select</h3>';
foreach($pdo->query( 'SELECT * FROM users;' ) as $row)
{
    //Fetching data
}

$sql = mysql_query('SELECT * FROM users;');
echo mysql_error();