While Loop (Defining Variable And Conducting Another While Loop)

[Clinton]

I posted something similar to this recently but the variable isn't defined, as it was in the last one.

 

I have two tables. The 'user' table contains the id, first name, and last name of the individual. The 'uinfo' table contains other pertinent info about the user.

 

I want the code to look at the 'uinfo' table where reviewed = 0 and gather all of the ID's (uid) of those members.

 

Then, based off of those ID's I want it to gather their names from the other table and list them so I can click on them. I'm just not quite sure how to do that. :-\

 

$sql="SELECT uid FROM uinfo WHERE reviewed='0'";
$result=mysql_query($sql);
while($row = mysql_fetch_array($result))
{
$uid = $row['uid'];

$sql="SELECT FirstName, LastName FROM users WHERE id='$uid'";
$result=mysql_query($sql);
while($row = mysql_fetch_array($result))
{
$admin = $row['admin'];
$FirstName = $row['FirstName'];
$LastName = $row['LastName'];
echo "<br><a href='blah.php?id=" . $uid . "'>" . $FirstName . " " . $LastName;
}
}

[MDCode]

If you want to select from multiple tables, you need to use a join. It's not good to use queries in loops.

[Clinton]

Join. That was it. Haven't used that since Access days. Thanks!