Re: JOIN 2 tables and filter results

[Rick James]

$e_colname = mysqli_real_escape_string($_POST['Postal_Code'] );
$e_colType = mysqli_real_escape_string($_POST['serviceType'] );
$query = "SELECT *
FROM delMenu INNER JOIN suppliers ON delMenu.suppID=suppliers.suppID
WHERE delPC = '$e_colname' AND '$e_colType' = serviceTypeID";

If this does not suffice, please provide
SHOW CREATE TABLE suppliers;
SHOW CREATE TABLE delMenu;

(Your names are confusing.)