Search the Community
Showing results for tags 'connecting tables'.
Found 1 result
-
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; } }