[PHP] Whats the correct syntax for using query results in a new query

[Terion Miller]

I'm trying to use the AdminID that returns from query #1 in the WHERE
AdminID = AdminID from Query 1

    $sql= "SELECT WorkOrderID, CreatedDate, Location, WorkOrderName,
AdminID, FormName, Status, Notes, pod FROM `workorders` WHERE AdminID =
'".$row['AdminID']."' ";

that isn't working and the query 1 does return in this case 3 AdminID's so
I'm thinking it's just the .$row['AdminID'] part that is wrong
and I have tried some different things but am not sure the correct term for
what I'm trying to do so I can' t seem to google answers....

Here is my query #1

  $query =  "SELECT `UserName`, `AdminID` FROM admin
      WHERE   Retail1 =  'YES' ";

    $result = mysql_query ($query) ;
    //$row = mysql_fetch_array($result);
    while ($row = mysql_fetch_row($result)){
    for ($i=0; $i<mysql_num_fields($result); $i++)
        echo $row[$i] . " ";

        }
Above returns 3 AdminID ... I also tried using the While statement in my
second query to return the sets but nothing... yet the code isn't breaking,
just returning 0

Thanks
Terion

Happy Freecycling
Free the List !!
www.freecycle.org
Over Moderation of Freecycle List Prevents Post Timeliness.
------------------------------------------------
Twitter?
http://twitter.com/terionmiller
------------------------------------------------
Facebook:
<a href="http://www.facebook.com/people/Terion-Miller/1542024891";
title="Terion Miller's Facebook profile" target=_TOP><img src="
http://badge.facebook.com/badge/1542024891.237.919247960.png"; border=0
alt="Terion Miller's Facebook profile"></a>
Joe DiMaggio  - "Pair up in threes."