有代码,请解题!

Question

就是把查到的所有的记录放到$message里发送出去,收到邮件显示的当然也就是你查到所有的内容了!

Answer 1

$message=$message.'
    <table>
    <tr>
    <td>'.$myrow['staffid'].'</div></td>
    <td>'.$myrow['staffname'].'</div></td>
    </tr>
    </table>
            '
这样循环的话不就把结果都加一起了吗，你上面只是得到了最后一个id和name。

Answer 2

$message=$message.'
    <table>
    <tr>
    <td>'.$myrow['staffid'].'</div></td>
    <td>'.$myrow['staffname'].'</div></td>
    </tr>
    </table>';用连接符连起来。。

Answer 3

$message .= '
    <table>
    <tr>
    <td>'.$myrow['staffid'].' </div> </td>
    <td>'.$myrow['staffname'].' </div> </td>
    </tr>
    </table>'; 
这样也可以。

Answer 4

        $email =$row4['email']; 
     $subject = "Work redeploy"; 
        $mysql="select * from _staffinfo where id in (".join(',',$txtsid);.")";
        $myrs=mysql_query($mysql);
        while($myrow=mysql_fetch_array($myrs)){
  $message .= '
    <table>
    <tr>
    <td>'.$myrow['staffid'].'</div></td>
    <td>'.$myrow['staffname'].'</div></td>
    </tr>
    </table>';       
        }        mail($row4['email'], $subject, $message);帮lz简写了下。。

Answer 5

$email =$row4['email']; 
        $subject = "Work redeploy"; 
        $mysql="select * from _staffinfo where id in (".join(',',$txtsid);.")";
        $myrs=mysql_query($mysql);
        $message = '<table>';
        while($myrow=mysql_fetch_array($myrs)){
                   $message .='
                    <tr> 
                    <td>'.$myrow['staffid'].'</div></td>
                    <td>'.$myrow['staffname'].'</div></td>
                    </tr>';           
        }
        $message .='</table>';        mail($row4['email'], $subject, $message); 
同一个表格里

Answer 6

$email =$row4['email']; 
$subject = "Work redeploy"; 
$mysql="select * from _staffinfo where id in (".join(',',$txtsid);.")";
$myrs=mysql_query($mysql);
$message='<table>';
while($myrow=mysql_fetch_array($myrs)){
       $message .= '
       <tr>
         <td>'.$myrow['staffid'].'</td>
         <td>'.$myrow['staffname'].'</td>
       </tr>;           
}
$message .= '</table>';
mail($row4['email'], $subject, $message);

Answer 7

$mysql="select * from _staffinfo where id in (".join(',',$txtsid);.")";
        $myrs=mysql_query($mysql); $message = '<style type="text/css">
<!--
body {
background-image: url(http://192.168.102.254/hrm-beta/images/beijing.jpg);
background-repeat: no-repeat;
}
}
#Layer1 {
position:absolute;
width:200px;
height:115px;
z-index:1;
left: 97px;
top: 25px;
}
.STYLE8 {color: #CC3300; font-size: x-small; }#f
{ 
   
border-collapse:collapse;
border: 1px solid #CC3300;}
.STYLE9 {font-size: x-small}
#Layer2 {
position:absolute;
width:64px;
height:66px;
z-index:1;
left: 847px;
top: 20px;
}-->
</style>
<br>
<br>
<div align="center">工作申調</div>
<hr color="#CC3300"  width="85%" align="center"/>
<br>
<table width="824" height="46" border="1" align="center" cellpadding="1" cellspacing="1" id="f">
    <tr>
    <td width="68" height="17"><div align="center"><span class="STYLE8">工號</span></div></td>
    <td width="69"><div align="center"><span class="STYLE8">姓名</span></div></td>
    <td width="101"><div align="center"><span class="STYLE8">原部門</span></div></td>
    <td width="86"><div align="center"><span class="STYLE8">原組別</span></div></td>
    <td width="88"><div align="center"><span class="STYLE8">原職務</span></div></td>
    <td width="100"><div align="center"><span class="STYLE8">調換日期</span></div></td>
    <td width="100"><div align="center"><span class="STYLE8">現部門</span></div></td>
    <td width="95"><div align="center"><span class="STYLE8">現組別</span></div></td>
    <td width="97"><div align="center"><span class="STYLE8">現職務</span></div></td>
  </tr>';
while($myrow=mysql_fetch_array($myrs))
   {

 
    $message .='
 <tr>
    <td height="17"><div align="center" class="STYLE9">'.$myrow['staffid'].'</div></td>
    <td><div align="center" class="STYLE9">'.$myrow['staffname'].'</div></td>
    <td><div align="center" class="STYLE9">電腦部</div></td>
    <td><div align="center" class="STYLE9">電腦部</div></td>
    <td><div align="center" class="STYLE9">主管</div></td>
    <td><div align="center" class="STYLE9">2008-12-26</div></td>
    <td><div align="center" class="STYLE9">財務部</div></td>
    <td><div align="center" class="STYLE9">財務部</div></td>
    <td><div align="center" class="STYLE9">主管</div></td>
  </tr>
  ';    }
 
 $message .='</table>
<br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />
<table width="823" border="0"  align="center">
  <tr>
    <td width="71">&nbsp;</td>
    <td width="71">&nbsp;</td>
    <td width="71">&nbsp;</td>
    <td width="71">&nbsp;</td>
    <td width="71">&nbsp;</td>
    <td width="71">&nbsp;</td>
    <td width="71">&nbsp;</td>
    <td width="71">&nbsp;</td>
    <td width="134">&nbsp;</td>
  </tr>
  <tr>
    <td height="21">&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td><div align="right">
      <a href="http://192.168.102.254/hrm-beta/attandance/redeployemail.php?action=yes&id=0" >YES<input type="button" name="" value="同意調換" /></a>
    </div></td>
    <td><a href="http://192.168.102.254/hrm-beta/attandance/redeployemail.php?action=on&id=1" >NO<input type="button" name="" value="不同意調換"/></a></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  </table>
<br>
 <img src="http://192.168.102.254/hrm-beta/images/Brilliant7.gif"/></body>';   
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=utf-8\r\n";$headers .= "From:".$row4['email']."<".$row4['email'].">\r\n";
$headers .= "Cc:".$row4['email']."\r\n";
$headers .= "Bcc:".$row4['email']."\r\n";
   
 mail($row4['email'], $subject, $message, $headers);可是发送以后什么也没有,程序有错,请问哪里不对呀!

Answer 8

重新贴一下,好检查一些        $mysql="select * from _staffinfo where id in (".join(',',$txtsid);.")"; 
        $myrs=mysql_query($mysql); $message = ' <style type="text/css"> 
<!-- 
body { 
background-image: url(http://192.168.102.254/hrm-beta/images/beijing.jpg); 
background-repeat: no-repeat; 
} 
} 
#Layer1 { 
position:absolute; 
width:200px; 
height:115px; 
z-index:1; 
left: 97px; 
top: 25px; 
} 
.STYLE8 {color: #CC3300; font-size: x-small; } #f 
{ 
  
border-collapse:collapse; 
border: 1px solid #CC3300; } 
.STYLE9 {font-size: x-small} 
#Layer2 { 
position:absolute; 
width:64px; 
height:66px; 
z-index:1; 
left: 847px; 
top: 20px; 
} --> 
</style> 
<br> 
<br> 
<div align="center">工作申調 </div> 
<hr color="#CC3300"  width="85%" align="center"/> 
<br> 
<table width="824" height="46" border="1" align="center" cellpadding="1" cellspacing="1" id="f"> 
    <tr> 
    <td width="68" height="17"> <div align="center"> <span class="STYLE8">工號 </span> </div> </td> 
    <td width="69"> <div align="center"> <span class="STYLE8">姓名 </span> </div> </td> 
    <td width="101"> <div align="center"> <span class="STYLE8">原部門 </span> </div> </td> 
    <td width="86"> <div align="center"> <span class="STYLE8">原組別 </span> </div> </td> 
    <td width="88"> <div align="center"> <span class="STYLE8">原職務 </span> </div> </td> 
    <td width="100"> <div align="center"> <span class="STYLE8">調換日期 </span> </div> </td> 
    <td width="100"> <div align="center"> <span class="STYLE8">現部門 </span> </div> </td> 
    <td width="95"> <div align="center"> <span class="STYLE8">現組別 </span> </div> </td> 
    <td width="97"> <div align="center"> <span class="STYLE8">現職務 </span> </div> </td> 
  </tr>'; 
while($myrow=mysql_fetch_array($myrs)) 
  { 
    $message .=' 
<tr> 
    <td height="17"> <div align="center" class="STYLE9">'.$myrow['staffid'].' </div> </td> 
    <td> <div align="center" class="STYLE9">'.$myrow['staffname'].' </div> </td> 
    <td> <div align="center" class="STYLE9">電腦部 </div> </td> 
    <td> <div align="center" class="STYLE9">電腦部 </div> </td> 
    <td> <div align="center" class="STYLE9">主管 </div> </td> 
    <td> <div align="center" class="STYLE9">2008-12-26 </div> </td> 
    <td> <div align="center" class="STYLE9">財務部 </div> </td> 
    <td> <div align="center" class="STYLE9">財務部 </div> </td> 
    <td> <div align="center" class="STYLE9">主管 </div> </td> 
  </tr> 
  ';     } $message .=' </table> 
<br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> 
<table width="823" border="0"  align="center"> 
  <tr> 
    <td width="71">&nbsp; </td> 
    <td width="71">&nbsp; </td> 
    <td width="71">&nbsp; </td> 
    <td width="71">&nbsp; </td> 
    <td width="71">&nbsp; </td> 
    <td width="71">&nbsp; </td> 
    <td width="71">&nbsp; </td> 
    <td width="71">&nbsp; </td> 
    <td width="134">&nbsp; </td> 
  </tr> 
  <tr> 
    <td height="21">&nbsp; </td> 
    <td>&nbsp; </td> 
    <td>&nbsp; </td> 
    <td>&nbsp; </td> 
    <td> <div align="right"> 
      <a href="http://192.168.102.254/hrm-beta/attandance/redeployemail.php?action=yes&id=0" >YES <input type="button" name="" value="同意調換" /> </a> 
    </div> </td> 
    <td> <a href="http://192.168.102.254/hrm-beta/attandance/redeployemail.php?action=on&id=1" >NO <input type="button" name="" value="不同意調換"/> </a> </td> 
    <td>&nbsp; </td> 
    <td>&nbsp; </td> 
    <td>&nbsp; </td> 
  </tr> 
  </table> 
<br> 
<img src="http://192.168.102.254/hrm-beta/images/Brilliant7.gif"/> </body>';   
$headers = "MIME-Version: 1.0\r\n"; 
$headers .= "Content-type: text/html; charset=utf-8\r\n"; $headers .= "From:".$row4['email']." <".$row4['email'].">\r\n"; 
$headers .= "Cc:".$row4['email']."\r\n"; 
$headers .= "Bcc:".$row4['email']."\r\n"; 
  
mail($row4['email'], $subject, $message, $headers); 可是发送以后什么也没有,程序有错,请问哪里不对呀!

Answer 9

看不出什么问题来,
1.贴出错提示
2.输入出$message看是什么东西 echo $message;
3.检查发邮件功能是否可以正确运行

Answer 10

$mysql="select * from _staffinfo where id in (".join(',',$txtsid);.")"; 这里多了一个";",现在显示出来了,多谢啦!