php 更新问题

来源：百度知道 编辑：UC知道 时间：2024/06/10 08:52:51
$dddd=mysql_query("update opinion set yesno='1' where id='$id'");
$sql="select * from opinion where yesno = '0' order by id";
$pp=mysql_query($sql);
echo "<center><table width=650 border=1 class='f'><tr><td width=40>序号</td><td width=250>投诉内容和意见</td><td width=60>填表日期</td><td width=60>填表时间</td><td width=60>审批内容</td></tr>";
while ($re=mysql_fetch_array($pp))
{
echo "<center><tr width=650 class='f'><td width=40>$re[id]</td><td width=250>$re[content]</td><td width=60>$re[date]</td><td width=60>$re[time]</td><td width=60><a href='$PHP_SELF?id=$re[id]&&passwordmem=$passwordmem&&gydmmem=$gydmmem'>审批</a></td></tr>";
}
echo"</table>";

if ($dddd){
echo

$dddd="update opinion set yesno='1' where id='$id'";
下面写，if(mysql_query($dddd)){

*****
}

<?
#在这里加上判断，如果传过来ID就说明是要审批，否则你每次都执行可不是每次都说审批成功
#其实更好的办法是在链接里加个参数shenpi=1,判断isset($_REQUEST['shenpi'])如果有，就执行审批操作
if($id){
$dddd=mysql_query("update opinion set yesno='1' where id='$id'");
}
$sql="select * from opinion where yesno = '0' order by id";
$pp=mysql_query($sql);
echo "<center><table width=650 border=1 class='f'><tr><td width=40>序号</td><td width=250>投诉内容和意见</td><td width=60>填表日期</td><td width=60>填表时间</td><td width=60>审批内容</td></tr>";
while ($re=mysql_fetch_array($pp))
{
echo "<center><tr width=650 class='f'><td width=40>$re[id]</td><td width=250>$re[content]</td><td width=6