Master/detail page - using multiple tables

[jarow]

I am trying to create a master/detail page (Dreamweaver Mx, PHP, mysql) using two tables (fauna, regiones) and I am unable to get all the fields to appear on the detail page mainly because I am unsure on how to write the queries. Here's what I have:

1. I have created the following JOINED recordset on the MASTER page

   SELECT *
   FROM fauna, regiones
   WHERE fauna.id=regiones.id

2. Now here is what I am not sure about...what do I put as the parameter to link to the detail page

   detail.php?RECID=<?php echo $row_recordset['???']; ?>

3. And finally on the DETAIL page, how do I write the query that would permit me to view fields from both tables

varRECID = $_GET[???]



SELECT *
FROM fauna,regiones
WHERE ? = varRECID

I hope I have supplied enough clear information for you to respond.

Many thanks

Jim

[Weedpacket]

One thing you can do to study the problem is to use [man]var_dump/man; to see what's inside it under which keys.