'do while' query row matches

BEFOR

I have a 'do while' repeat region that returns new site registrants.

This returns results as:

<?php echo $row_Main['MemID']; ?> //primary id

Now what I need to do is add a column on the row, and place a 2nd query that will match on this same value.

I'm doing this to make conditional echoes -- its an admin panel, and I simply want to echo hyperlinks for tasks to perform on each site registrant. When the 2nd query evaluates !=='' I'll echo 'done', if not, link to a form to perform the referred to task. Roughly within the repeat col row:

if (2nd query !=='') {echo 'done'} else{echo hyperlink to do this}

How can $row_Main['MemID']; value be matched on within seperate queries that are placed within its repeat region?

Dreamweaver runtime variable: shouldn't Post pull this if its already being echoed on the row?
$HTTP_POST_VARS($row_Main['MemID'])

halojoy

BEFOR wrote:
I have a 'do while' repeat region that returns new site registrants.

This returns results as:
<?php echo $row_Main['MemID']; ?> //primary id
Now what I need to do is add a column on the row, and place a 2nd query that will match on this same value.

I'm doing this to make conditional echoes -- its an admin panel, and I simply want to echo hyperlinks for tasks to perform on each site registrant. When the 2nd query evaluates !=='' I'll echo 'done', if not, link to a form to perform the referred to task. Roughly within the repeat col row:
<?php

if (2nd query !=='') {
     // echo 'done'
} else{
    // echo hyperlink to do this
}

/***

How can $row_Main['MemID'];   value be matched on within seperate queries that are placed within its repeat region?

Dreamweaver runtime variable: shouldn't Post pull this if its already being echoed on the row?

$HTTP_POST_VARS($row_Main['MemID'])

***/

?>

Interesting question.
I think however you are on right track here
and maybe you have solved it by your self
now

/halojoy

BEFOR

I've decided its easier and gives better user results if I just create a new Left Join query for 'do while'. At the present the 'do while' is based on only one table, no joins, and passes the main primary id which all these tables can be joined on. It returns as many rows as I'd like, of course.

It contains successive links for forms for setting values, and each link-to-form inserts values. When inserted the link will shut off, as I said.

However my 'do while' with the LEFT JOIN (joined to all tables taking the avlues) will only return a single result without going beserk. But I think the LEFT JOIN problem id due to a couple of tables with composite keys.

-Was directed to ways of dealing with this on this forum but I don't quite get the notation. Something about parent id's:

Drakla's

SELECT f1.cat FROM frog f1 LEFT JOIN frog f2
ON f1.cat = f2.pid WHERE f2.pid IS NULL;