<?PHP
echo 'The database is: ';
if(!mysql_connect('localhost', 'username', 'password'))
echo 'DOWN';
else
echo 'UP';
?>
EDIT: Aw heck, I'll even do a one-liner:
<?php echo 'The database is: ' . (mysql_connect('localhost', 'username', 'password') ? 'UP' : 'DOWN'); ?>