Search the Community

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; } }

First, the idea: I want to post announcements for all users and then allow them to "clear" them off of their announcement list. I have two tables. Table 1 (announce) holds announcements. It has the fields of id, date, and info. Table 2 (ackannounce) holds the fact that a user has "cleared/acknowledged" an announcement and contains the fields aid (announcement ID) and uid (user ID). Essentially I want the code to check the table 'ackannounce' and then display whatever announcements have NOT been "cleared/acknowledged" by the user. The code below, however, is not accomplishing that (all the variables are fine and populate appropriately). Any help in demistifying this for me would be greatly appreciated. <? $sql="SELECT * FROM ackannounce WHERE uid='$uid'"; $result=mysql_query($sql); ?> <p> <center> <font color="green"> <table width="85%" border="3" cellspacing="0" cellpadding="0"> <? while($row = mysql_fetch_array($result)) { $aid = $row['aid']; $sql2="SELECT * FROM announce WHERE NOT id = '$aid'"; $result2=mysql_query($sql2); while($row = mysql_fetch_array($result2)) { $id = $row['id']; $info = $row['info']; ?> <tr><td width="20%">Date: <? echo date("m-d-Y",strtotime($row['date']));?> </td><td><br><? echo $info; ?><br> <br><a href="ackannounce.php?aid=<?echo $id;?>&uid=<?echo $uid; ?>">Acknowledge/Clear</a><br> </td></tr> <? }} ?> </table> </font> </center> </p>

Hi everyone, I am still learning PHP, I am getting better a little, but i am still struggle with while and foreach loop to create few columns. I create one column with while or foreach, but I couldn't figure to create few columns intsead of one long column. Can you help me or make any suggest? Thank you so much