The aim is to display a list of members from a sql database. I am a total novice & have created a form using Web Designer & put a placeholder on it. In the placeholder is the following code:

<?php
$host="localhost"; // Host name
$username="xxx"; // Mysql username
$password="yyy"; // Mysql password
$db_name="db_members"; // Database name
$tbl_name="members"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$user_result = "SELECT MembershipName, Email, PhoneHome, PhoneBus, PhoneMobile, MembershipType from members ORDER BY MembershipName;";
$qry = mysql_query($user_result) OR die(mysql_error());

// echo mysql_num_rows($qry);

echo "<center>";
echo "<table CELLPADDING=10 border =1 >";

// Column headings
echo "<tr align='center'>";
echo "<td>MemName</td>";
echo "<center><td>Email</td>";
echo "<center><td>Home</td>";
echo "<center><td>Bus</td>";
echo "<center><td>Mob</td>";
echo "<center><td>Type</td>";
echo "</tr>";

while($myrow = mysql_fetch_array($qry))
{
echo "<tr>";
echo "<td>".$myrow['MembershipName']."</td>";
echo "<td>".$myrow['Email']."</td>";
echo "<td>".$myrow['PhoneHome']."</td>";
echo "<td>".$myrow['PhoneBus']."</td>";
echo "<td>".$myrow['PhoneMobile']."</td>";
echo "<td>".$myrow['MembershipType']."</td>";
echo "</tr>";
// $user_array = mysql_fetch_assoc($qry);
}

echo "</table>";
mysql_close();
?>

This code works fine if run as a .PHP file.

I have also tried saving the code as a php file and using an include statement

Nothing appears in the placeholder.
Any ideas pleas?
t