How to "echo" .. PHP/Mysql

<?php
/* Connecting, selecting database */
$link = msql_connect('localhost', 'username', 'password')
    or die('Could not connect : ' . msql_error($link));

msql_select_db('database', $link)
    or die('Could not select database');

/* Issue SQL query */
$Query = "select count(*) AS address_count from address where blenderp=1";
$result = msql_query($query, $link) or die('Query failed : ' . msql_error());

while ($row = msql_fetch_array($result)) {
 echo $row['address_count'];
}

/* Close connection */
msql_close($link);
?>

<?php
$dbname = 'xxx'; // db name 
$dbuser = 'xxx'; // db username 
$dbpass = 'xxx'; // db password 
$dbhost = 'localhost';     // db host, localhost should suffice. 
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error()); 
mysql_select_db($dbname, $conn) or die(mysql_error()); 
require('header.php');
$result = mysql_query('SELECT count(*) AS `address_count` FROM `address` WHERE `blenderp`=1') or die(mysql_error());
$result = mysql_result($result, 0, 0);
echo $result;
require('footer.php');

// you do not need to call mysql_cose(), it happens automagically at end of script.
?>