我在mysql中创建了一个查询,它是:
select
address,state,id
from
addressdata
where
address in (select address from addressdata group by address having count(*) > 1)
但我面临着一个问题:如何在MysqlAjax表编辑器中实现查询?
我在mysql-ajax表编辑器中以以下方式定义了列:
function initiateEditor()
{
$tableColumns['ID'] = array(
'display_text' => 'ID',
'perms' => 'VT',
);
$tableColumns['State'] = array(
'display_text' => 'State',
'perms' => 'VT',
);
$tableColumns['Address'] = array(
'display_text' => 'Address',
'perms' => 'VT',
'table_fun' => array(&$this,'formatLink'),
'view_fun' => array(&$this,'formatLink')
);
}
function formatLink($col,$val,$row)
{
$query1=mysql_query("select Address from addressdata group by Address having count(*) > 1") or die(mysql_error());
}
但这似乎不像正常的查询那样工作,请帮助解决这个问题。
嗨,使用这样的东西,它可能对你的有用
$this->Editor->setConfig('sqlFilters',"Address != '' and Address IN(select address from addressdata group by address having count(*) > 1)");