判断用户是否在栏目中发布过文章
开源系统 更新 2018-09-26 17:21:33
laowt
laowt
如何判断在当前自定义模块(services)的栏目中发布过文章
{if $ci->db->where('cid', $id)->where('uid', $member.uid)->count_all_results('1_services')}
发布过,显示服务链接
{else}
未发布显示发布链接
{/if}
如上写法显示数据库错误
Error Number: 1054Unknown column 'cid' in 'where clause'SELECT COUNT(*) AS `numrows` FROM `dr_1_services` WHERE `uid` = 13 AND `cid` IS NULLFilename: /data/home/qxu1608220182/htdocs/cache/templates/templates.mobile.ixhoo.home.services.list.html.mobile..cache.phpLine Number: 17{if $ci->db->where('catid', $catid)->where('uid', $member.uid)->count_all_results('1_services')} 发布过,显示服务链接 {else} 未发布显示发布链接 {/if}