Using Arrays and Querying the database

[Anon]

Here is my problem

$result = mysql_query("SELECT * FROM <table> WHERE SERVER_ID=$ID)";

while ($myrow = mysql_fetch_row($result)) {

**NOW I wanna pull something from another table using the myrow[0] array..

$server = mysql_query("SELECT * FROM <table1> WHERE SERVER_ID=$myrow[0])";
while ($row = mysql_fetch_row($server)) {
echo "$myrow[0]&nbsp;&nbsp;&nbsp$row[1]";

---

I'm guessing b/c I'm using a array I need to do a while loop to tell the database to keep going until done? However I'm now sure how to do that... if I take awhile the 2nd while and $server I get my results just fine, its just when I try to pull from another table using the $myrow[0]...

Any Ideas?!!?!?!

Thanks!