Quite new to php so please bare with me but this is a weird situation. I'm pulling a number of fields from a MySql table using '*' option in my sql select statement. The output shows any field but 2. Has anyone heard of the problem before.

My code is listed below:-

<?php

include ("../securedata/user_auth.php");
/* Connect to database */
$db_connect=mysql_connect($dbhost,$dbusername,$dbpassword);
if (!$db_connect) {
die('Sorry we are having a technical problem, please try again later! (Error LJG01)');
}
mysql_select_db($dbdatabase);

/* Get gig dates from database */
$result = mysql_query("SELECT * FROM `GigGuide` WHERE Active = 'No' ORDER BY `Year` ASC, `Month` ASC, `Date` ASC");
if (!$result) {
die('Sorry we are having a technical problem, please try again later! (Error LJG03)');
}
while ($row = mysql_fetch_array($result)) {
$GigID = $row['ID'];
$GigTimeStamp = $row['TimeStamp'];
$GigMonth = $row['Month'];
$GigYear = $row['Year'];
$GigDate = $row['Date'];
$GigTitle = $row['Title'];
$GigName = $row['Name'];
$GigTown = $row['Town'];
$GigCountry = $row['Country'];
$GigMap = $row['Map'];
$GigMoreinfo1 = $row['GigMoreinfo1'];
$GigContect4tickets = $row['Contact4tickets'];
$GigEventdate = $row['Eventdate'];
$GigTemp = $row['Temp'];
$GigStartTime = $row['StartTime'];
$GigMonthStr = date("F", mktime(0, 0, 0, $GigMonth, 1, 2000));
if ($curYear != $GigYear) {
print "<tr>\n";
print "<td colspan='10' valign='top' class='gigmonth'>\n";
print "<h3>$GigYear</h3>\n";
print "</td>\n";
print "</tr>\n";
$curYear = $GigYear;
$curMonth = "";
$curTitle = "";
}
if ($curMonth != $GigMonth) {
print "<tr>\n";
print "<td colspan='10' valign='top' class='gigmonth'>\n";
print "<h3>$GigMonthStr</h3>\n";
print "</td>\n";
print "</tr>\n";
$curMonth = $GigMonth;
$curTitle = "";
}
if ($curTitle != $GigTitle) {
print "<tr>\n";
print "<td colspan='10' valign='top' class='discogrow'>\n";
print "<h4>$GigTitle</h4>\n";
print "</td>\n";
print "</tr>\n";
$curTitle = $GigTitle;
}
if ($GigMoreinfo1 == "") {$GigMoreinfo1 = "&nbsp;";}
if ($GigName == "") {$GigName = "&nbsp;";}
if ($GigTown == "") {$GigTown = "&nbsp;";}
if ($GigCountry == "") {$GigCountry = "&nbsp;";}
if ($GigStartTime == "") {$GigStartTime = "&nbsp;";}
if ($GigContact4tickets == "") {$GigContact4tickets = "&nbsp;";}
if ($GigMap == "") {$GigMap = "&nbsp;";}
if ($GigEventdate == "") {$GigEventdate = "&nbsp;";}
if ($GigTemp == "") {$GigTemp = "&nbsp;";}
print "<tr>\n";
print "<td valign='top' class='discogrow'>$GigDate/$GigMonth/$GigYear</td>\n";
print "<td valign='top' class='discogrow'>$GigName</td>\n";
print "<td valign='top' class='discogrow'>$GigTown</td>\n";
print "<td valign='top' class='discogrow'>$GigCountry</td>\n";
print "<td valign='top' class='discogrow'>$GigStartTime</td>\n";
print "<td valign='top' class='discogrow'>$GigContact4tickets</td>\n";
print "<td valign='top' class='discogrow'>$GigMap</td>\n";
print "<td valign='top' class='discogrow'>$GigEventdate</td>\n";
print "<td valign='top' class='discogrow'>$GigMoreinfo</td>\n";
print "</tr>\n";
}

?>

I've tried moving fields around, excluding some to no avail!!!!!

Please help.

Thanks in advance.