Unknown column 'dr_1_news_category_data.fwlx' in 'where clause' 搜索問題 →
SELECT count(*) as t FROM `dr_1_news` WHERE `dr_1_news`.`catid`=1 AND `dr_1_news`.`id` IN (SELECT `id` FROM `dr_1_news_category_data` WHERE `dr_1_news_category_data`.`fwlx`="apartment") AND (`dr_1_news`.`fwlx`="apartment") ORDER BY NULL
搜索選功能是自帶的。參考文檔:《搜索函數寫法》
我在模塊內容字段加加了
<a class="{if !$params.fwlx}選中高亮{/if}" href="{dr_search_url($params, 'fwlx', NULL, 'news')}">不限</a>
{php $field = dr_field_options(65);}
{loop $field $value $name}
<a class="{if $value==$params.fwlx}選中高亮{/if}" href="{dr_search_url($params, 'fwlx', $value, 'news')}">{$name}</a></label>
{/loop}
mysqli_sql_exception #1054
Unknown column 'dr_1_news_category_data.fwlx' in 'where clause' 搜索問題 →
SELECT count(*) as t FROM `dr_1_news` WHERE `dr_1_news`.`catid`=1 AND `dr_1_news`.`id` IN (SELECT `id` FROM `dr_1_news_category_data` WHERE `dr_1_news_category_data`.`fwlx`="apartment") AND (`dr_1_news`.`fwlx`="apartment") ORDER BY NULL
看代碼沒問題,是不是寫錯模塊名了?
試試這個
還是不對,默認的共享模塊news,用欄目模型字段就正常