下面是出错的那部分内容
$lastbbs = mssql_query("select top 1 announceid,username,postuserid,body From Dv_bbs1 Where rootid=$topicid ORDER BY announceid DESC");
$lastbbsresult=mssql_fetch_array($lastbbs);
//更新主数据表
$lastdata=$lastbbsresult[1]."\$".$lastbbsresult[0]."\$".$lastpostdateandtime."\$".substr($lastbbsresult[3],0,10).chr(0)."\$\$".$lastbbsresult[2]."\$".$topicid."\$".$fid."\$";
//die("update dv_topic set Lastpost='$lastdata' where topicid=$topicid");
mssql_query("update dv_topic set Lastpost='$lastdata' where topicid=$topicid");
$lastbbs = mssql_query("select top 1 announceid,username,postuserid,body From Dv_bbs1 Where rootid=$topicid ORDER BY announceid DESC");
$lastbbsresult=mssql_fetch_array($lastbbs);
//更新主数据表
$lastdata=$lastbbsresult[1]."\$".$lastbbsresult[0]."\$".$lastpostdateandtime."\$".substr($lastbbsresult[3],0,10).chr(0)."\$\$".$lastbbsresult[2]."\$".$topicid."\$".$fid."\$";
//die("update dv_topic set Lastpost='$lastdata' where topicid=$topicid");
mssql_query("update dv_topic set Lastpost='$lastdata' where topicid=$topicid");
最后一句
问题解决了
是里面有单引号的问题终于把PW转DV的程序写出来了
今天一天就做了这么一件事情