viewmessage.php

通达OA部分源代码

<?
include_once "logincheck.php"; 
include_once "myconnect.php";
$id=$_REQUEST["id"];
$rst=mysql_fetch_array(mysql_query("select * from sbbleads_messages where sb_id=$id"));
?>
<div align="center">
  <table width="70%" border="0" align="center" cellpadding="2" cellspacing="10">
    <tr bgcolor="#004080"> 
      <td height="25" colspan="2"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>&nbsp;View 
        Message</strong></font></td>
    </tr>
    <tr> 
      <td width="40%" align="right" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">To:</font></strong></td>
      <td> <font size="2" face="Arial, Helvetica, sans-serif"> 
        <?  
			$to=mysql_fetch_array(mysql_query("select * from sbbleads_members where sb_id=".$rst["sb_tid"]));
			echo $to["sb_username"];?>
        </font></td>
    </tr>
    <tr> 
      <td width="40%" align="right" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">Subject:</font></strong></td>
      <td><font size="2" face="Arial, Helvetica, sans-serif"><? echo $rst["sb_subject"];?></font></td>
    </tr>
    <tr> 
      <td width="40%" align="right" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">Message:</font></strong></td>
      <td><font size="2" face="Arial, Helvetica, sans-serif"><? echo str_replace("\n","<br>",$rst["sb_message"]);?></font></td>
    </tr>
    <tr> 
      <td width="40%" align="right" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif">From:</font></strong></td>
      <td> <font size="2" face="Arial, Helvetica, sans-serif"> 
        <? 
			$from=mysql_fetch_array(mysql_query("select * from sbbleads_members where sb_id=".$rst["sb_fid"]));
			echo $from["sb_username"];?>
        </font></td>
    </tr>
  </table>
</div>