<?php
$mysql_user = "root";
$mysql_pass = "password";
$mysql_host = "localhost";
$mysql_db = "test";

$con = mysql_connect($mysql_host, $mysql_user, $mysql_pass) or die/mysql_error());

$select_db = mysql_select_db($mysql_db, $con) or die(mysql_error));

$sql = "SELECT * FROM test";
$res = mysql_query($sql);

while ($field = mysql_fetch_array($res))
{
$id = $field['id'];
$name = $field['name'];

echo 'ID: ' . $field['id'] . '<br />';
echo 'Name: ' . $field['name'] . '<br /><br />';
}

?>