Close to a full solution...
Ray, i've attempted to add another couple of JOINS to the following sql you showed me recently;
<?php
mysql_select_db($database_HouseyConnect, $HouseyConnect);
$query_WADApropsubtbl = "SELECT hopicfolder, hopicimagename, propRooms, propType, propmaintbl.propVal, propSDesc FROM propmaintbl
LEFT OUTER JOIN homepics ON PropPrimePic = hopicsidx
LEFT OUTER JOIN propRooms ON propBeds = propRoomCnt
LEFT OUTER JOIN propstyle ON propType=PropStyleCnt
LEFT OUTER JOIN propval ON propmaintbl.propVal = propValCnt
WHERE propRID = " . $row_WADApropmaintbl['propRID'];
$WADApropsubtbl = mysql_query($query_WADApropsubtbl, $HouseyConnect) or die(mysql_error());
$row_WADApropsubtbl = mysql_fetch_assoc($WADApropsubtbl);
?>
The first two are good, but 3 & 4 return the error; Unknown column 'propValCnt' in 'where clause' and Unknown column 'propSaleCnt' in 'where clause' instead of the results page, when i apply the respective search criteria.
I've followed the same principles as 1&2 - well at least i thought i had;
Join TABLE1 ON TABLE2_TARGET_FIELD_NAME = TABLE1_INDX_FIELD_MATCHING_TABLE2_TARGET_FIELD_NAME
Not sure why failing?