Search the Community

Hi everyone I would like to know if anyone has ever successfully been able to display a TinyMCE editor in a while loop? It only displays the first loop, and not the second while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { echo '<form method="post" style="margin-top:20px;"><table> <tr> <td>Content Name</td> <td><input type="hidden" name="idwidget" value="'.$row["id"].'" /><input type="text" name="name" value="'.$row["content_name"].'" /></td> </tr> <tr> <td>Content</td> <td><textarea id="mcecontent" class="mcecontent" name="mcecontent" rows="15" cols="80">'.$row["content"].'</textarea></td> </tr> <tr> <td>Active</td> <td>'; if($row["active"] == "1"){ echo '<input type="checkbox" name="active" checked="checked" />'; } else { echo '<input type="checkbox" name="active" />'; } echo '</td> </tr> </table>'; } It is suppose to display for mcecontent textarea.

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>