Join 2 tables and filer results

PHP
1

I’m fairly new to PHP and MySQL. Here’s what I’m trying to accomplish:

I have two tables:

  1. suppliers
  2. delMenu

The common field in each is suppID (the supplier ID). I have two variables being passed from the previous page via a form post

  1. delPC (delivery Postal Code)
  2. serviceType

These are both fields that are in the table delMenu. I need to join the tables delMenu and suppliers, where all records in delMenu match delPC and serviceType from the form submitted.

I have looked at some info/tutorials on MySQL Joins, but haven’t really been able to make much sense as far as my needs go.

Any help is greatly appreciated.

2

Never mind. I was able to get assistance from another (more active) forum.