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