how to make php / mysql code usable on both installations

hi there,
this question is in an attempt to conclude code compatibility accross installations.
attached you will find the data differences between the two installations of the code - CanopyXchange & QuoteMe, and TruckCapXchange.
now in the supplier manager, there are filters - which currently only work on the regional fields (red values), as well as the Status and Type fields (blue values).
now the latest code filters the suppliers on the Supplier Manager by using the above mentioned fields. (tcx installation records in attached xlsx document).
i however, need to implement that where suppliers have multiple regional bindings via the 4_servicesuppliers table, that those are used in the regional filters instead. the latest php and compiled mysql query where these supplier records are filtered - is as follows (allowing for multiple regions to be selected):

function getrecords($country="",$state="",$county="",$zip="",$status="",$type="") {
	global $conn;
	$wsql = array();
	if ($country!="") {
		$f_country = explode(",",$country);
		for ($i = 0; $i < count($f_country); $i++) {
			$f_country[$i] = "bigint_CountryID = ".$f_country[$i];
		}
		array_push($wsql,"(".implode(" OR ",$f_country).")");
	}
	if ($state!="") {
		$f_state = explode(",",$state);
		for ($i = 0; $i < count($f_state); $i++) {
			$f_state[$i] = "bigint_StateID = ".$f_state[$i];
		}
		array_push($wsql,"(".implode(" OR ",$f_state).")");
	}
	if ($county!="") {
		$f_county = explode(",",$county);
		for ($i = 0; $i < count($f_county); $i++) {
			$f_county[$i] = "bigint_CountyID = ".$f_county[$i];
		}
		array_push($wsql,"(".implode(" OR ",$f_county).")");
	}
	if ($zip!="") {
		$f_zip = explode(",",$zip);
		for ($i = 0; $i < count($f_zip); $i++) {
			$f_zip[$i] = "bigint_ZipCodeID = ".$f_zip[$i];
		}
		array_push($wsql,"(".implode(" OR ",$f_zip).")");
	}
	if ($status!="") {
		$f_status = "smallint_SupplierStatus = ".$status;
		array_push($wsql,$f_status);
	}
	if ($type!="") {
		$f_type = "tinyint_DefaultType = ".$type;
		array_push($wsql,$f_type);
	}
	$tsql = "SELECT * FROM 5_suppliers ".
			(($country!=""||$state!=""||$county!=""||$zip!=""||$status!=""||$type!="")?"WHERE ".implode(" AND ",$wsql):"").
			" ORDER BY text_SupplierName ASC;";
	$result = mysql_query_errors($tsql , $conn , __FILE__ , __LINE__ );
	if ($result) {
		while ($row = mysql_fetch_array($result)) {
			echo "	<supplier>\n";
			echo "		<supplierid>" . $row["bigint_SupplierID"] . "</supplierid>\n";
			echo "		<suppliername>" . xmlentities($row["text_SupplierName"]) . ": " . xmlentities($row["text_ContactFirstName"]) . " " . xmlentities($row["text_ContactSurname"]) . " (" . $row["bigint_ContactTel"] . ")" . "</suppliername>\n";
			echo "	</supplier>\n";
		}
	}
}

Select allOpen in new window

a more to the point question i guess would be, how do i alter the php/mysql to use the regional binding records if available, instead of the supplier records? i am guessing i will need to do a left join select - but am unsure about the exact implementation of if the secondary table has records or not.
many thanks in advance for the assistance provided.
CX---QM-vs-TCX-supplier-manager-.xlsx
supplier-manager.jpg