Jason,
I was first trying to use FULL OUTER JOIN only to discover you can't use these with MySQL and have to use UNION and UNION ALL with LEFT and RIGHT JOIN. I have tried this and I can not seem to get the results I am looking for as it does not seem to filter the results properly for the user in SESSION.
Here is the query I have tried.
$getID_rsSummary = "-1";
if (isset($_SESSION['members_id'])) {
$getID_rsSummary = $_SESSION['members_id'];
}
mysql_select_db($database_LA, $LA);
$query_rsSummary = sprintf("SELECT * FROM members LEFT JOIN properties ON members.property_id = properties.property_id LEFT JOIN enquiries ON members.members_id = enquiries.members_id UNION ALL SELECT * FROM members RIGHT JOIN properties ON members.property_id = properties.property_id LEFT JOIN enquiries ON members.members_id = enquiries.members_id UNION ALL SELECT * FROM members RIGHT JOIN properties ON members.property_id = properties.property_id RIGHT JOIN enquiries ON members.members_id = enquiries.members_id WHERE members.members_id = %s ", GetSQLValueString($getID_rsSummary, "int"));
$rsSummary = mysql_query($query_rsSummary, $LA) or die(mysql_error());
$row_rsSummary = mysql_fetch_assoc($rsSummary);
$totalRows_rsSummary = mysql_num_rows($rsSummary);
Any pointers? ;-)