petewale

Hi guys,

Sorry to bother you with this but I am getting nothing outputted in my WP page and I am at a loss as to why. Would one of you kind people help me out?

Here is my code

[insert_php]
mysql_connect(“localhost”,”USERNAME”,”PASSWORD”)
or die(mysql_error());

mysql_select_db(“DB”)
or die(mysql_error());

$result = mysql_query(“SELECT * FROM activities WHERE id=6”);

while($row = mysql_fetch_array($result))
{

$day=$row[‘DAY’];
$course=$row[‘Course’];
$location=$row[‘Location’];
$price=$row[‘Price’];
$duration=$row[‘Duration’];
$startDate=$row[‘StartDate’];
$startTime=$row[‘StartTime’];
$courseDes=$row[‘CourseDes’];
$sessionDes=$row[‘SessionDes’];
$contactName=$row[‘ContactName’];
$contactEmail=$row[‘ContactEmail’];
$contactNumber=$row[‘ContactNumber’];

echo “<table>”;
echo “<tr><td>Day:</td><td>”.$day.”</td></tr>”;
echo “<tr><td>Course:</td><td>”.$course.”</td><td>Location:</td><td>”.$location.”</td></tr>”;
echo “<tr><td>Price:</td><td>”.$day.”</td><td>Duration:</td><td>”.$duration.”</td></tr>”;
echo “<tr><td height=”10″> </td></tr>”;
echo “<tr><td>Description:</td><td>”.$courseDes.”</td></tr>”;
echo “<tr><td height=”10″> </td></tr>”;
echo “<tr><td>Each Session Includes:</td><td>”.$sessionDes.”</td></tr>”;
echo “<tr><td height=”10″> </td></tr>”;
echo “<tr><td>Coach:</td><td>”.$contactName.”</td></tr>”;
echo “<tr><td>Email:</td><td>”.$contactEmail.”</td></tr>”;
echo “<tr><td>Number:</td><td>”.$contactNumber.”</td></tr>”;
echo “<tr><td height=”20″> </td></tr>”;
echo “</table>”;

}
[/insert_php]