Below is my code. It acts like it loads ok but the data doesn't show up in the DB. Any help would be great.
<?
//Connection Variables
$dbhost = "localhost"; // Usually localhost.
$dbuser = "user"; // If you have no username, leave this space empty.
$dbpass = "pass"; // The same applies here.
$dbname = "fsbo"; // This is the main database you connect to.
$usertable = "homes"; // This is the table you made.
//Set VARS for formatting
$baseFont = "<font face=\"Arial, Helvetica, sans-serif\" size=2>";
$upFont = "<font size=2>";
$beginResultsTable = "<table width=520 border=0 align=center>\n\t<tr>\n\t\t<td colspan=3>\n\n";
$endResultsTable = "\n\t\t</td>\n\t</tr>\n</table>";
$cellColor0 = "fefbdc";
$cellColor1 = "ffffff";
//Connect
$db = mysql_connect($dbhost,$dbuser,$dbpass);
@mysql_select_db( "$dbname",$db) or die( "Unable to select database");
//$query = "INSERT INTO homes (first,last,address,position) VALUES ('$first','$last','$address','$position')";
$query = "INSERT INTO homes (homeid, propertyid, brokerid, price, strNumber, strDir, strName, strType, area, daHood, subdiv, city, county, state, zip, yrBuilt, taxes, primSchl, jrhiSchl, highSchl, schlDist, geoType, propType, sellName, phone1type, phone1, phone2type, phone2, phone3type, phone3, phone4type, phone4, sellEmail, sellAddr, startDate, endDate, listDate, listStat, houseStat, descrip, minidesc, ohStart, ohEnd, ohStarttime, ohEndtime, ohRundate, videoURL, vrURL, photoMain, photo1, photo2, photo3, photo4, photo5, photo6, photo7, photo8, quanBed, quanBath, quanBthFull, quanBthHalf, quanBthThre, dimMaster, dimBR1, dimBR2, dimBR3, dimBR4, dimBR5, dimBR6, dimLiving, dimDining, dimKitchen, dimLaundry, dimBasement, dimUtility, dimGrtRoom, dimGameRoom, dimFamily, dimRecRoom, dimBreakNk, dimDen, houseSize, houseStyle, houseType, garageType, lotSize, lotDims, otherRooms, baseType, condition, air, fireplace, heating, utilities, floortype, laundry, pool, security, wheelchair, amenities, architect, exterior) VALUES ('', '$propertyid', '$brokerid', '$price', '$strNumber', '$strDir', '$strName', '$strType', '$area', '$daHood', '$subdiv', '$city', '$county', '$state', '$zip', '$yrBuilt', '$taxes', '$primSchl', '$jrhiSchl', '$highSchl', '$schlDist', '$geoType', '$propType', '$sellName', '$phone1type', '$phone1', '$phone2type', '$phone2', '$phone3type', '$phone3', '$phone4type', '$phone4', '$sellEmail', '$sellAddr', '$startDate', '$endDate', '$listDate', '$listStat', '$houseStat', '$descrip', '$minidesc', '$ohStart', '$ohEnd', '$ohStarttime', '$ohEndtime', '$ohRundate', '$videoURL', '$vrURL', '$photoMain', '$photo1', '$photo2', '$photo3', '$photo4', '$photo5', '$photo6', '$photo7', '$photo8', '$quanBed', '$quanBath', '$quanBthFull', '$quanBthHalf', '$quanBthThre', '$dimMaster', '$dimBR1', '$dimBR2', '$dimBR3', '$dimBR4', '$dimBR5', '$dimBR6', '$dimLiving', '$dimDining', '$dimKitchen', '$dimLaundry', '$dimBasement', '$dimUtility', '$dimGrtRoom', '$dimGameRoom', '$dimFamily', '$dimRecRoom', '$dimBreakNk', '$dimDen', '$houseSize', '$houseStyle', '$housetype', '$garageType', '$lotSize', '$lotDims', '$otherRooms', '$baseType', '$condition', '$air', '$fireplace', '$heating', '$utilities', '$floortype', '$laundry', '$pool', '$security', '$wheelchair', '$amenities', '$architect', '$exterior')";
echo "
<head>
<title>House Loaded Successfully</title>
</head>
<body topmargin=\"10\" leftmargin=\"0\" bgcolor=\"#FFCC00\" link=\"#FFFFFF\" vlink=\"#5C697A\" alink=\"#FFFFFF\" text=\"#FFFFFF\" style=\"font-family: Verdana; font-size: 8pt; color: #FFFFFF\">
<div align=\"center\">
<center>
<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" width=\"400\" id=\"AutoNumber1\">
<tr>
<td bgcolor=\"2D460A\" height=\"25\">
<p align=\"center\"><font size=\"2\" color=\"#FFFFFF\"><b>House Loaded Successfully</b></font></td>
</tr>
</table>
</center>
</div>
</body>
";
?>
