Joinng 2 MySQL tables

Not sure if I'm doing this correctly...

The two tables are Suppliers (houses all suppliers) and delMenu (houses delivery postal codes, fees, etc).

I need to join two tables (suppID is the common filed in both).

I have a recordset (rsDelMenu) that lists all records in delMenu that match two variables posted from the form on the previous page. I now need to merge the results of this recordset with all records in the Suppliers table, where suppID = suppID


=== rsDelMenu ===

$colname_rsDelMenu = "-1";
if (isset($_POST['serviceType'])) {
$colname_rsDelMenu = $_POST['serviceType'];
}
$colPC_rsDelMenu = "-1";
if (isset($_POST['Postal_Code'])) {
$colPC_rsDelMenu = $_POST['Postal_Code'];
}
mysql_select_db($database_connData, $connData);
$query_rsDelMenu = sprintf("SELECT * FROM delMenu WHERE serviceTypeID = %s AND delPC = %s", GetSQLValueString($colname_rsDelMenu, "int"),GetSQLValueString($colPC_rsDelMenu, "int"));
$rsDelMenu = mysql_query($query_rsDelMenu, $connData) or die(mysql_error());
$row_rsDelMenu = mysql_fetch_assoc($rsDelMenu);
$totalRows_rsDelMenu = mysql_num_rows($rsDelMenu);

see this page for details on creating a sql join query:

http://www.w3schools.com/sql/sql_join.asp

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);

yes, update the recordset to a join, and do not change anything for the where clause.

Where exactly should I put JOIN code? I keep getting an error...

Never mind. Got it. Thanks, Jason. As always, your help is greatly appreciated!

I have setup a JOIN. However, the filtering does not seem to be working. All records show up...

SELECT *
FROM delMenu INNER JOIN suppliers ON delMenu.suppID=suppliers.suppID
WHERE delPC = colname AND colType = serviceTypeID

========
colname gets runtime value from: $_POST['Postal_Code']
colType gets runtime value from:$_POST['serviceType']

Am I approaching this correctly?

looks correct, send a copy of the page and a link where i can see the problem.

p/m

It looks like the repeat region might be the issue...???
The same menu seems to be repeating a few times...