I took a look at the page Jason. Thank you. However, I'm kinda stuck when it comes to filtering the joined tables based on the two variables posted by the form on the previous page...
I'm thinking the easiest thing would be to update this recordset to a Join?
$colname_rsNeo = "-1";
if (isset($_POST['Postal_Code'])) {
$colname_rsNeo = $_POST['Postal_Code'];
}
$colType_rsNeo = "-1";
if (isset($_POST['serviceType'])) {
$colType_rsNeo = $_POST['serviceType'];
}
mysql_select_db($database_connData, $connData);
$query_rsNeo = sprintf("SELECT * FROM delMenu WHERE delPC = %s AND %s = serviceTypeID", GetSQLValueString($colname_rsNeo, "text"),GetSQLValueString($colType_rsNeo, "int"));
$rsNeo = mysql_query($query_rsNeo, $connData) or die(mysql_error());
$row_rsNeo = mysql_fetch_assoc($rsNeo);
$totalRows_rsNeo = mysql_num_rows($rsNeo);