User Notes</a>
<?php
$notes = $dbcon->Execute("SELECT * FROM helpnotes where helpid = " . $called->Fields("id") . " order by id asc") or die($dbcon->ErrorMsg());
while (!$notes->EOF) {
if ($notes->Fields("notes") != NULL) {
$users = $dbcon->Execute("SELECT name FROM users where id = " . $notes->Fields("user") . "") or die($dbcon->ErrorMsg());
?>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td bgcolor="#FFFFCC" class="name"><strong>Notes</strong></td>
<td bgcolor="#FFFFCC" class="name"><div align="right">posted by
<?php
echo $users->Fields("name");
?>
on <?php
echo DoTimeStamp($notes->Fields("date"), "n/j/y");
?>
| <a href="javascript:void(0)"
ONCLICK="open('help_notes.php?id=<?php
echo $called->Fields("id");
?>
&update=<?php
echo $notes->Fields("id");
?>
','miniwin2','scrollbars=1,resizable=1,width=650,height=500')">Edit</a></div></td>
</tr>
<tr>
<td colspan="2" bgcolor="#CCCCCC" class="name"><?php
echo converttext($notes->Fields("notes"));
?>
</td>
<tr>
<td width="25%">Date Created</td>
<td width="25%"><div align="left"><?php
echo DoDateTime($r->Fields("datecreated"), "n/j/y");
?>
</div></td>
<td width="25%">Date Modified</td>
<td width="25%"> <div align="left"> <?php
if ($updated_time = $r->Fields("updated")) {
echo $updated_time;
}
?>
</div></td>
<!--<td width="25%"> <div align="left"> <?php
if ($updated_time = $r->Fields("updated")) {
echo DoTimeStamp(strtotime($updated_time), "n/j/y");
}
?>
</div></td>-->
</tr>
<tr>
<td>Created By</td>
<td><div align="left"> <?php
if ($user_id_creator = $r->Fields("enteredby")) {
$users = $dbcon->Execute("SELECT name FROM users where id =" . $user_id_creator . "") or die($dbcon->ErrorMsg());
echo $users->Fields("name");
}
?>
</div></td>
<td>Last Modified By</td>
<td><div align="left"> <?php