<?php

$db_host = 'localhost';
$db_name = 'znzpromo_subscriptions';
$db_user = 'znzpromo';
$db_pass = 'eastandw';

$dbh = new PDO("mysql:host=$db_host; dbname=$db_name;", $db_user, $db_pass);
$sql = "SELECT * FROM Subscriptions";
$sth = $dbh->prepare($sql);
$result=$sth->execute();
$result = $sth->fetchAll(PDO::FETCH_ASSOC);

echo $result[0]['Name'];

?>