感谢回复,我知道有这个3个表的关联,
$empire->gettotal("INSERT INTO {$dbtbpre}ecms_news_check(classid,username,title,tel,zhuanye,age,tjtime,newstime,truetime,lastdotime) VALUES('10','广点通推送','这是姓名2','这的电话','兴趣专业','年龄','提交时间','{$hsltime}','{$hsltime}','{$hsltime}');"); $empire->gettotal("insert into {$dbtbpre}ecms_news_index(id,classid,newstime,truetime,lastdotime,havehtml) select id,classid,newstime,truetime,lastdotime,havehtml from {$dbtbpre}ecms_news_check"); $empire->gettotal("update {$dbtbpre}ecms_news_index set checked=0"); $empire->gettotal("insert into {$dbtbpre}ecms_news_data_1(id,classid) select id,classid from {$dbtbpre}ecms_news_check");
我这样写了后 的确是可以看到,但是我在后台点修改的时候 字段内容都是为空,请问是我写错了吗,我希望的是 通过SQL语句添加的文章都是非审核状态
|