[iamatahd]

To anyone who can help -- I'm trying to load up two recordsets in Dreamweaver MX and have the second one be based on information in the first one. In other words, if record 001 in my first recordset has in once of it's columns that a related record is 010, I would like my second recordset to call up everything to do with 010.

Is this possible?

I've been at coding for all of one week. Bought Dreamweaver to build a site and quickly discovered it's limitations, so now I'm working mostly in PHP with what I can glean from these boards.

Thanks for any advice.

D

[ChristGuy]

Greetingz...

When you build your second query you'd use the field with the first value...

PHP Code:

$recClients = MySQL_Query("SELECT * FROM Clients");

$Client = MySQL_Fetch_Array($recRecordSet1);



$recSales = MySQL_Query("SELECT * FROM Sales WHERE ClientID=" . $Client["ClientID"]); 

Hope this helps...