rsammy Posted January 15, 2007 Share Posted January 15, 2007 i amworking on a module where the office manager receives an email about a patient. the manager can then approve the message/patient for billing or can forward it to a biller in the group!i am stuck at the piont where the manager approves it for billing. when 'Approve for Billing' button is clicked on the email body in view.php, a table in the database, navigation should flow (back) to main.php - where the navigation started! and, 'approved_for_billing' field in dcn table of the database should be updated with the value 'Yes'.i am able to send the navigation back to main.php to show the exact same screen as where it came from. however, i am not able to update the dcn table with 'Yes' for the specified field! heres the code in main.php:[code]<?PHP require_once ("../config.php"); include ("phpInclude/cookie.php"); $dcn_approved_for_billing = $_GET["requestforApproval"]; $dcn_tran_id = $_GET["mesgtran_ID"]; //$dcn_approved_for_billing=$_POST["requestforApproval"]; //$dcn_approved_for_billing="YES"; $dcn_tran_id=$_POST["mesgtran_ID"]; print ("APP for Billing is ...: " .$dcn_approved_for_billing. "TRAN ID is ...: " . $dcn_tran_id); if (($dcn_approved_for_billing=='YES') OR ($dcn_approved_for_billing=='NO')) { print ("APP for Billing is ...: " .$dcn_approved_for_billing); $querydcn = "UPDATE dcn SET dcn_approved_for_billing='$dcn_approved_for_billing' WHERE dcn_tran_ID='$dcn_tran_id' "; mysql_query($querydcn); } $current = getdate(); $current_date = $current["mon"] . "/" . $current["mday"] . "/" . $current["year"]; $rowNum=$_GET["rowNum"]; if (isset ($_GET["m1"])) { $m1=$_GET["m1"]; $d1=$_GET["d1"]; $y1=$_GET["y1"]; $dbdate="$y1-$m1-$d1"; $m2=$_GET["m2"]; $y2=$_GET["y2"]; $d2=$_GET["d2"]; $dbdates="$y2-$m2-$d2"; } if (empty($m1)) { $m1=$current["mon"]; if ((!isset($d1)) || (empty($d1))) { $d1=$current["mday"]; } if ((!isset($y1)) || (empty($y1))) { $y1=$current["year"]; } $dbdate ="$y1-$m1-$d1"; //print "$dbdate"; $m2=$current["mon"]; $d2=$current["mday"]; $y2=$current["year"]; $dbdates ="$y2-$m2-$d2"; } if ($dbdate == $current["year"] . "-" . $current["mon"] . "-" . $current["mday"]) { ?> <script language="JavaScript"> //10000 is 10 Seconds var refreshTime = 60000; setTimeout('document.location=document.location',refreshTime); </script> <? } ?> <? $query = "SELECT user_fname, user_lname, user_email, user_logon, user_auth FROM user_mgr WHERE user_id='$userid' "; //echo "$query"; $result = mysql_query($query); $row = mysql_fetch_array($result); $user_fname= $row["user_fname"]; $user_lname=$row["user_lname"]; $USER_NAME = $user_fname ." ". $user_lname; $email_addy = $row["user_email"]; $user_logon=$row["user_logon"]; $user_auth=$row["user_auth"]; if ($user_auth == "3" OR $user_auth == "2") { $query= "SELECT grp_name FROM group_details"; } else { $query= "SELECT grp_name, user_auth FROM group_details, user_mgr WHERE user_mgr.user_fname='$user_fname' AND user_mgr.user_lname='$user_lname' AND user_mgr.user_grp_id=group_details.grp_id"; } //echo "$query"; $result=mysql_query($query); $row = mysql_fetch_array($result); $group_name = $row["grp_name"]; if ($user_auth == "2") { $queryz="SELECT message, user_id, status, from_p, subject, DATE_FORMAT(received, '%m/%d/%Y') as date, ID, to_email, time_sent, grp_id FROM messages WHERE received >='$dbdates' and received <='$dbdate' order by ID DESC "; $querysent="SELECT messages.message, messages.user_id, messages.status, messages.from_p, messages.subject, DATE_FORMAT(messages.received, '%m/%d/%Y') as date, messages.ID, messages.to_email, messages.time_sent, messages.grp_id FROM messages, sent_messages WHERE messages.received >='$dbdates' and messages.received <='$dbdate' and messages.id = sent_messages.message_id and sent_messages.user_id='$userid' order by messages.ID DESC"; } else { $queryz = "SELECT message, m.user_id, status, from_p, subject, DATE_FORMAT(received, '%m/%d/%Y') as date, ID, to_email, time_sent, grp_id FROM messages m,user_mgr u WHERE request !='settodelete' and received >='2006-12-25' and received <='2006-12-25' AND m.to_email =u.user_email and u.user_id = '111' order by ID DESC "; $querysent="SELECT messages.message, messages.user_id, messages.status, messages.from_p, messages.subject, DATE_FORMAT(messages.received, '%m/%d/%Y') as date, messages.ID, messages.to_email, messages.time_sent, messages.grp_id FROM messages, sent_messages WHERE messages.request !='settodelete' AND messages.user_id='$userid' and messages.received >='$dbdates' and messages.received <='$dbdate' and messages.id = sent_messages.message_id and sent_messages.user_id='$userid' order by messages.ID DESC"; } $resultz = mysql_query($queryz); $num_rowz = mysql_num_rows($resultz); $rowz= mysql_fetch_array($resultz); $inboxcounter = $num_rowz; $resultsent = mysql_query($querysent); $num_rowsent = mysql_num_rows($resultsent); $sentcounter = $num_rowsent;?><html><head><title>ABC</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><link rel='stylesheet' type='text/css' href='css/styleSheet.css'><SCRIPT language="JavaScript" src="js/tree.js"></SCRIPT><SCRIPT language="JavaScript"><?PHP //Navigation File require_once ("../nav.php");?></SCRIPT></head><body bgcolor="#FFFFFF" text="#000000"><table width="900" border="0" cellspacing="0" cellpadding="0"> <tr align="left" valign="top"> <td colspan="2"> <img src="images/title_bar.gif" width="900" height="69"></td> </tr> <tr> <td align="left" valign="top" width="273"> <table width="243" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="10"><img src="images/clear.gif" width="10" height="15"></td> <td width="213"><div align="center"> <p><b><font color="#006699"><?PHP print($group_name); ?></b><b><BR> User:</b> <?PHP print("$USER_NAME"); ?></p> </div></td> </tr> <tr> <td width="10"> </td> <td width="213" bgcolor="#006699"> <div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FFFFFF"><b>Folders</b></font></div></td> </tr> <tr> <td width="10"> </td> <td width="213" align="left" valign="top"> <table width="240" border="1" cellspacing="0" cellpadding="0" bordercolor="#006699"> <tr> <td width="236" align="left" valign="top"> <table width="222" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="222"> </td> </tr> <tr> <td> <div align="left"> <img src="images/selectedfolder-icon.gif" width="16" height="13"> <a href="main.php">Inbox </a></div></td> </tr> <tr> <td> <div align="left"> <img src="images/selectedfolder-icon.gif" width="16" height="13"> <a href="sent.php">Sent Items </a></div></td> </tr> <tr> <td> <div align="left"> <img src="images/compose-button.gif" width="21" height="15"> <a href="compose.php?m1=".$m1. "&d1=".$d1 . "&y1=".$y1. "&m2=".$m2 . "&d2=".$d2 . "&y2=".$y2">Compose</a></div></td> </tr> <tr> <td> <?PHP if($USER_LEVEL == 3) {?> <div align="center"><img src="images/quit-button.gif" width="19" height="25" align="absmiddle"><a href="index.php">Logout</a></div> <? } ?> </td> </tr> <tr> <td> </td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td width="10"> </td> <td width="213"> <div align="center"></div></td> </tr> <tr> <td width="10" rowspan="4"> </td> <td width="213" align="left" valign="top"> </td> </tr> <?PHP if($USER_LEVEL != 3) {?> <tr> <td align="left" valign="top" bgcolor="#006699"><div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FFFFFF"><b>Office Manager </b></font></div></td> </tr> <tr> <td align="left" valign="top"> </td> </tr> <tr> <td align="left" valign="top" wrap="soft"> <SCRIPT language="JavaScript"> tree.loadState() tree.display() </SCRIPT> </td> </tr> <tr> <td width="10" height="64"> <?PHP }?> </td> </tr> </table></td> <td width="631" align="left" valign="top"><p> </p> <table width="94%" height="361" border="1" align="right" cellpadding="0" cellspacing="0" bordercolor="#006699"> <tr> <td bgcolor="#006699"><strong><font color="#FFFFFF">INBOX</font></strong></td> </tr> <tr> <td height="343" align="left" valign="top"> <form action="main.php" method="get" name="getmessages" id="getmessages"> <table width="84%" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="1%"> </td> <td width="2%"> </td> <td width="41%"> </td> <td width="46%"> </td> <td width="10%"> </td> </tr> <tr> <td> </td> <td> </td> <td><div align="right"><font class="inputLbl">From Date: </font></div></td> <td> <input name="m2" type="text" class="txtboxsm" value="<? if (isset($m2)){ print ("$m2"); } else { print("$m2"); }?>" size="3" maxlength="2" > / <input name="d2" type="text" class="txtboxsm" value="<? if (isset($d2)){ print ("$d2"); }?>" size="3" maxlength="2" > / <input name="y2" type="text" class="txtboxsm" value="<? if (isset($y2)){ print ("$y2"); }?>" size="6" maxlength="4" ></td> <td> </td> </tr> <tr> <td height="24"> </td> <td> </td> <td><div align="right"><font class="inputLbl">To Date: </font></div></td> <td> <input name="m1" type="text" class="txtboxsm" value="<? if (isset($m1)){ print ("$m1"); }?>" size="3" maxlength="2" > / <input name="d1" type="text" class="txtboxsm" value="<? if (isset($d1)){ print ("$d1"); }?>" size="3" maxlength="2" > / <input name="y1" type="text" class="txtboxsm" value="<? if (isset($y1)){ print ("$y1"); }?>" size="6" maxlength="4" > </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td><font class ="SELECT"> <input class="sbttn" type="submit" name="Submit" value="Search"> </font></td> <td> </td> </tr> </table> </form> <form name="viewMessages" method="post" action="viewMessage.php"> <table width="572" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="11"><img src="images/clear.gif" width="10" height="15"></td> <td width="1"> </td> <td> </td> <td> <input type="hidden" name="userid" value="<? print ("$userid"); ?>"> </td> <td> </td> <td> </td> <td><img src="images/clear.gif" width="10" height="15"></td> </tr> <tr> <td colspan="2" bordercolor="#006699" bgcolor="#0089B7"></td> <td width="34" bordercolor="#006699" bgcolor="#0089B7"></td> <td width="213" bordercolor="#006699" bgcolor="#0089B7"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#FFFFFF"><b>From</b></font></td> <td width="215" bordercolor="#006699" bgcolor="#0089B7"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#FFFFFF"><b>To</b></font></td> <td width="225" bordercolor="#006699" bgcolor="#0089B7"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FFFFFF"><b>Subject</b></font></td> <td width="140" bordercolor="#006699" bgcolor="#0089B7"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#FFFFFF"><b>Received</b></font></td> <td width="13" bordercolor="#006699" bgcolor="#0089B7"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#FFFFFF"> </font></td> </tr> <?PHP$num_results=mysql_num_rows($resultz); $i=1; if(!isset($rowNum)) { $rowNum = 0; } $rowNumHold = $rowNum; $count = 1; $limit_results = 25; if ($num_rowz > 0) { for($q=0;$q<$limit_results && $rowNum < $num_rowz;$q++) { if(mysql_data_seek($resultz, $rowNum++)) { if ($i++%2) { print ("<tr bgcolor=\"#cccccc\">"); } else { print ("<tr>"); } if ($rowz = mysql_fetch_array($resultz)) {?> <td colspan="2"> </td> <td> <?PHP if($rowz["status"] == 1) { print("<img src=\"images/unopened-icon.gif\" width=\"18\" height=\"18\" border=\"0\">"); } else { print("<img src=\"images/opened-icon.gif\" width=\"18\" height=\"18\" border=\"0\">"); } ?> <td><a href="view.php<?PHP print("?mess_id=".$rowz["ID"]. "&m1=".$m1. "&d1=".$d1 . "&y1=".$y1. "&m2=".$m2 . "&d2=".$d2 . "&y2=".$y2 ."&requestforApproval=".$requestforApproval ."&mesgtran_ID=".$mesgtran_ID); ?>" > <?PHP $from_p = $rowz["from_p"]; $fromquery="select user_fname, user_lname, user_email FROM user_mgr WHERE user_email='$from_p'"; $resultfrom=mysql_query($fromquery); $fromrow= mysql_fetch_array($resultfrom); $from_fname = $fromrow["user_fname"]; $from_lname = $fromrow["user_lname"]; print($from_fname . " ". $from_lname); print("</div></td>"); ?></a></td> <td><a href="view.php<?PHP print("?mess_id=".$rowz["ID"]. "&m1=".$m1. "&d1=".$d1 . "&y1=".$y1. "&m2=".$m2 . "&d2=".$d2 . "&y2=".$y2 ."&requestforApproval=".$requestforApproval ."&mesgtran_ID=".$mesgtran_ID ); ?>" > <?PHP $to_email = $rowz["to_email"]; $reciepientquery="select user_fname, user_lname, user_email FROM user_mgr WHERE user_email='$to_email'"; $resultreciepient=mysql_query($reciepientquery); $reciepientrow= mysql_fetch_array($resultreciepient); $to_fname = $reciepientrow["user_fname"]; $to_lname = $reciepientrow["user_lname"]; print($to_fname . " ". $to_lname); print("</div></td>"); ?></a></td> <td><a href="view.php<?PHP print("?mess_id=".$rowz["ID"]. "&m1=".$m1. "&d1=".$d1 . "&y1=".$y1. "&m2=".$m2 . "&d2=".$d2 . "&y2=".$y2 ."&requestforApproval=".$requestforApproval ."&mesgtran_ID=".$mesgtran_ID ); ?>"><?PHP print($rowz["subject"]); ?></a></td> <td><a href="view.php<?PHP print("?mess_id=".$rowz["ID"]. "&m1=".$m1. "&d1=".$d1 . "&y1=".$y1. "&m2=".$m2 . "&d2=".$d2 . "&y2=".$y2 ."&requestforApproval=".$requestforApproval ."&mesgtran_ID=".$mesgtran_ID ); ?>"><?PHP print($rowz["date"]."<br>".$rowz["time_sent"]. " ET"); ?></a></td> <td colspan="8"> </td> </tr><? } }}?> <tr> <td colspan="2"> </td> <td colspan="4"><div align="center"></div> <div align="center"> <? $pages = intval($num_rowz/$limit_results); if($num_rowz%$limit_results) { $pages++; } print("<b>Page</b> "); for($z=0;$z<$pages;$z++) { print("<a href=\"main.php?rowNum="); print ($limit_results*$z); print("&m1="); print($m1); print("&d1="); print($d1); print("&y1="); print ($y1); print("&m2="); print ($m2); print("&d2="); print($d2); print("&y2="); print ($y2); print("\">"); if(($z + 1) == (($rowNumHold/$limit_results) + 1)) { print("["); print($z + 1); print("]"); } else { print($z + 1); } print("</a> "); } print(" ($num_rowz records found)"); print("</div></td>"); print("</tr>"); }elseif ($num_results=='0') {?><tr> <td width="2" ></td> <td width="34" ></td> <td width="231"> No Messages ...</td> <td width="175"> </td> <td width="107" > </td> <td width="13"> </td> </tr> <?PHP } ?> </div> <td colspan="8"> </td> </tr> </table> </form> </td> </tr> </table> </td> </tr></table></body></html><?PHP mysql_close();?>[/code]and heres the code in view.php[code]<?PHP require_once ("../config.php"); include ("phpInclude/cookie.php"); $mess_id=$_GET["mess_id"]; $m1=$_GET["m1"]; $d1=$_GET["d1"]; $y1=$_GET["y1"]; $m2=$_GET["m2"]; $d2=$_GET["d2"]; $y2=$_GET["y2"]; $requestforApproval=$_GET["requestforApproval"]; $mesgtran_ID=$_GET["mesgtran_ID"]; $dbdates="$y2-$m2-$d2"; $dbdate ="$y1-$m1-$d1"; $query = "SELECT user_fname, user_lname, user_email, user_logon, user_auth FROM user_mgr WHERE user_id='$userid' "; $result = mysql_query($query); $row = mysql_fetch_array($result); $user_fname= $row["user_fname"]; $user_lname=$row["user_lname"]; $USER_NAME = $user_fname ." ". $user_lname; $email_addy = $row["user_email"]; $user_logon=$row["user_logon"]; $user_auth = $row["user_auth"]; if ($user_auth == "3" OR $user_auth == "2") { $query= "SELECT grp_name FROM group_details"; } else { $query= "SELECT grp_name FROM group_details, user_mgr WHERE user_mgr.user_fname='$user_fname' AND user_mgr.user_lname='$user_lname' AND user_mgr.user_grp_id=group_details.grp_id"; } $result=mysql_query($query); $row = mysql_fetch_array($result); $group_name = $row["grp_name"]; $query = "UPDATE messages SET status=2 WHERE user_id='$userid' AND ID='$mess_id'"; mysql_query($query); if ($user_auth == "2") { $querydisplay = "SELECT messages.message, messages.user_id, messages.status, messages.from_p, messages.subject, DATE_FORMAT(messages.received, '%m/%d/%Y') as date, messages.ID, messages.to_email, messages.time_sent, messages.grp_id, messages.tran_ID, user_mgr.user_fname, user_mgr.user_lname, user_mgr.user_id, user_mgr.user_email FROM messages, user_mgr WHERE messages.ID='$mess_id' AND user_mgr.user_id = messages.user_id"; } else { $querydisplay = "SELECT messages.message, messages.user_id, messages.status, messages.from_p, messages.subject, DATE_FORMAT(messages.received, '%m/%d/%Y') as date, messages.ID, messages.to_email, messages.time_sent, messages.grp_id, messages.tran_ID FROM messages WHERE messages.ID='$mess_id' AND messages.request !='settodelete'"; } $resultdisplay = mysql_query($querydisplay); $num_rows = mysql_num_rows($resultdisplay); $rowdisplay = mysql_fetch_array($resultdisplay); $from_p = $rowdisplay["from_p"]; $to_email = $rowdisplay["to_email"]; $mesgtran_ID = $rowdisplay["tran_ID"]; $messagevariable = $rowdisplay["message"]; $icnquery="SELECT visit_type from visit_mgr where palm_tran_ID='$mesgtran_ID'"; $icnresult=mysql_db_query("$database[dbname]", $icnquery); $icnr = mysql_fetch_array($icnresult); $visit_type=$icnr["visit_type"]; $dcnquery="SELECT * from dcn where dcn_tran_ID='$mesgtran_ID'"; $dcnresult = mysql_db_query("$database[dbname]", $dcnquery); $r = mysql_fetch_array($dcnresult); $dcn_posted_for_billing=$r["dcn_posted_for_billing"]; $dcn_approved_for_billing=$r["dcn_approved_for_billing"]; $dcn_tran_id=$r["dcn_tran_ID"]; //Delete the message if (isset($_POST["action"])) { $mess_id=$_POST["mess_id"]; $query = "UPDATE messages set request ='settodelete' WHERE user_id='$userid' AND ID='$mess_id'"; mysql_query($query); header("Location: main.php?m1=".$_POST["m1"]."&d1=".$_POST["d1"]."&y1=".$_POST["y1"]."&m2=".$_POST["m2"]."&d2=".$_POST["d2"]."&y2=".$_POST["y2"]); exit; } //Reply to the message if (isset($_POST["reply"])) { header("Location: compose.php?mess_id=".$_POST["mess_id"]. "&reply=".$_POST["reply"]. "&m1=".$_POST["m1"]."&d1=".$_POST["d1"]."&y1=".$_POST["y1"]."&m2=".$_POST["m2"]."&d2=".$_POST["d2"]."&y2=".$_POST["y2"]."&inboxcounter=".$_POST["inboxcounter"]."&sentcounter=".$_POST["sentcounter"]); exit; } //forward the message if (isset($_POST["forward"])) { header("Location: compose.php?mess_id=".$_POST["mess_id"]. "&reply=".$_POST["reply"]. "&m1=".$_POST["m1"]."&d1=".$_POST["d1"]."&y1=".$_POST["y1"]."&m2=".$_POST["m2"]."&d2=".$_POST["d2"]."&y2=".$_POST["y2"]."&inboxcounter=".$_POST["inboxcounter"]."&sentcounter=".$_POST["sentcounter"]); exit; } //approve for billing if (isset($_POST["approval"])) { $requestforApproval='Yes'; header("Location: main.php?mess_id=".$_POST["mess_id"]. "&reply=".$_POST["reply"]. "&m1=".$_POST["m1"]."&d1=".$_POST["d1"]."&y1=".$_POST["y1"]."&m2=".$_POST["m2"]."&d2=".$_POST["d2"]."&y2=".$_POST["y2"]."&requestforApproval=".$_POST["requestforApproval"]."&mesgtran_ID=".$_POST["mesgtran_ID"]); exit; } //Print the message if (isset($_POST["print"])) { header("Location: printMCtemplate.php?mess_id=".$_POST["mess_id"]. "&print=".$_POST["print"]. "m1=".$_POST["m1"]."&d1=".$_POST["d1"]."&y1=".$_POST["y1"]."&m2=".$_POST["m2"]."&d2=".$_POST["d2"]."&y2=".$_POST["y2"]); exit; }?><html><head><title>ABC</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><link rel='stylesheet' type='text/css' href='css/styleSheet.css'><SCRIPT language="JavaScript" src="js/tree.js"></SCRIPT><SCRIPT language="JavaScript"><?PHP //Navigation File //require_once ("phpInclude/nav.php"); require_once ("../nav.php");?></SCRIPT></head><body bgcolor="#FFFFFF" text="#000000"><table width="900" border="0" cellspacing="0" cellpadding="0"><tr align="left" valign="top"><td colspan="2"><img src="images/title_bar.gif" width="900" height="69"></td></tr><tr><td align="left" valign="top" width="219"><table width="271" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="10"><img src="images/clear.gif" width="10" height="15"></td> <td width="235" valign="top"> <div align="center"> <p><b><font color="#006699"><?PHP print($group_name); ?></font></b><font color="#006699"></font><br> <b><font color="#006699">User:</font></b><font color="#006699"> <?PHP print($USER_NAME); ?></font></p> <font color="#006699"></font></div></td> <td width="1"> </td> <td width="25"><img src="images/clear.gif" width="10" height="15"></td> </tr> <tr> <td width="10"> </td> <td width="235" bgcolor="#006699"> <div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FFFFFF"><b>FOLDERS</b></font></div></td> <td width="1"> </td> <td width="25"> </td> </tr> <tr> <td width="10"> </td> <td width="235" align="left" valign="top"> <table width="253" border="1" cellspacing="0" cellpadding="0" bordercolor="#006699"> <tr> <td width="249" align="left" valign="top"> <table width="224" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="224"> </td> </tr> <tr> <td> <div align="left"> <img src="images/selectedfolder-icon.gif" width="16" height="13"> Inbox </div></td> </tr> <tr> <td> <div align="left"> <img src="images/selectedfolder-icon.gif" width="16" height="13"> Sent Items </div></td> </tr> <tr> <td> <div align="left"> <img src="images/compose-button.gif" width="21" height="15"> <a href="compose.php">Compose</a></div></td> </tr> <tr> <td> <?PHP if($USER_LEVEL == 3) { ?> <div align="center"><img src="images/quit-button.gif" width="19" height="25" align="absmiddle"><a href="index.php">Logout</a></div> <? } ?> </td> </tr> <tr> <td> </td> </tr> </table></td> </tr> </table></td> <td width="1"> </td> <td width="25"> </td> </tr> <tr> <td width="10"> </td> <td width="235"> <div align="center"></div></td> <td width="1"> </td> <td width="25"> </td> </tr> <tr> <td width="10"> </td> <td width="235" align="left" valign="top"> <?PHP if($USER_LEVEL != 3) { ?> <table width="212" border="0" cellspacing="0" cellpadding="0" bordercolor="#006699"> <tr> <td width="208" align="left" valign="top"> <table width="250" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="247" bgcolor="#006699"> <div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FFFFFF"><b>Office Manager </b></font></div></td> </tr> <tr> <td> </td> </tr> <tr> <td> <SCRIPT language="JavaScript"> tree.loadState() tree.display() </SCRIPT> </td> </tr> <tr> <td> </td> </tr> </table></td> </tr> </table> <?PHP } ?> </td> <td width="1"> </td> <td width="25"> </td> </tr> <tr> <td width="10"> </td> <td width="1"> </td> <td width="25"> </td> </tr> </table></td><td width="681" align="left" valign="top"><form name="viewMessages" method="post" action="view.php"> <p><br> </p> <table width="681" border="0" cellspacing="0" cellpadding="0"><tr> <td width="16"><img src="images/clear.gif" width="10" height="15"></td><td width="601" bgcolor="#0099CC"><div align="right"> <input type="hidden" name="mess_id" value="<?PHP print($rowdisplay["ID"]); ?>"> <input type="hidden" name="m1" value="<?PHP print("$m1"); ?>"> <input type="hidden" name="d1" value="<?PHP print("$d1"); ?>"> <input type="hidden" name="y1" value="<?PHP print("$y1"); ?>"> <input type="hidden" name="m2" value="<?PHP print("$m2"); ?>"> <input type="hidden" name="d2" value="<?PHP print("$d2"); ?>"> <input type="hidden" name="y2" value="<?PHP print("$y2"); ?>"> <input type="hidden" name="inboxcounter" value="<?PHP print("$inboxcounter"); ?>"> <input type="hidden" name="sentcounter" value="<?PHP print("$sentcounter"); ?>"> <input type="hidden" name="messagevariable" value="<?PHP print("$messagevariable"); ?>"> <input class="sbttnW" type="submit" name="forward" value="Forward"> <input class="sbttnW" type="submit" name="reply" value="Reply"> </div></td><td width="64"><img src="images/clear.gif" width="25" height="15"></td></tr> <td width="16"> </td><td><table width="601" border="1" cellspacing="0" cellpadding="0" bordercolor="#0099CC"> <tr><td width="597"> <table width="597" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="15"> </td> <td width="85"> </td> <td width="270"> </td> <td width="212"> </td> <td width="37"><img src="images/clear.gif" width="10" height="15"></td> </tr> <tr> <td width="15"> </td> <td width="85"> <div align="left"><b>From:</b></div></td> <td colspan="2"> <?PHP $queryfrom = "SELECT user_fname, user_lname, user_email FROM user_mgr WHERE user_email='$from_p' "; $resultfrom = mysql_query($queryfrom); $rowfrom = mysql_fetch_array($resultfrom); $fname= $rowfrom["user_fname"]; $lname=$rowfrom["user_lname"]; //$uname = $user_fname ." ". $user_lname; $uname = $fname ." ". $lname; print ($uname); ?> </td> <td width="37"> </td> </tr> <tr> <td> </td> <td><b>To:</b></td> <td colspan="2"> <?PHP $queryto = "SELECT user_fname, user_lname, user_email FROM user_mgr WHERE user_email='$to_email'"; $resultto = mysql_query($queryto); $rowto = mysql_fetch_array($resultto); $tofname= $rowto["user_fname"]; $tolname=$rowto["user_lname"]; $toname = $tofname ." ". $tolname; print ($toname); ?> </td> <td> </td> </tr> <tr> <td width="15"> </td> <td width="85"> <div align="left"><b>Received:</b></div></td> <!--<td colspan="2"> <?PHP print($rowdisplay["date"]); ?> </td>--> <td colspan="2"> <?PHP print($rowdisplay["date"]." ".$rowdisplay["time_sent"] . " ET"); ?> </td> <td width="37"> </td> </tr> <tr> <td width="15"> </td> <td width="85"> <div align="left"><b>Subject:</b></div></td> <td colspan="2"> <?PHP print($rowdisplay["subject"]); ?> </td> <td width="37"> </td> </tr> <tr> Link to comment https://forums.phpfreaks.com/topic/34316-help-with-postget/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.