Question
display results from two tables
Hello,
I have two tables, PRODUCTS and MANUFACTURERS
I can show the results of all the products passing a querystring in the url stating the product category. not a problem.
but now, I do I show the results from both tables: PRODUCTS and MANUFACTURERS where the query string should be the manufacturer name.
the two tables have this foreign key:
PRODUCTS >> manufacturerid
MANUFACTURERS>> manufacturerid
other related fields of the tables:
PRODUCTS>> prodimage, price, description
MANUFACTURERS>> manufacturer name
and the query string should be the manufacturer name, which is not hte manufacturer id.
Mauricio
??
I have two tables, PRODUCTS and MANUFACTURERS
I can show the results of all the products passing a querystring in the url stating the product category. not a problem.
but now, I do I show the results from both tables: PRODUCTS and MANUFACTURERS where the query string should be the manufacturer name.
the two tables have this foreign key:
PRODUCTS >> manufacturerid
MANUFACTURERS>> manufacturerid
other related fields of the tables:
PRODUCTS>> prodimage, price, description
MANUFACTURERS>> manufacturer name
and the query string should be the manufacturer name, which is not hte manufacturer id.
Mauricio
??
AdChoices