我有一人在小地点修建了海关编码管理系统,现在我可以让开发商持有。 我在试图查看我的现场时,会发现这一错误:
You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version
for the right syntax to use near order by sortorder at line 1:
select path, title
from pages
where parent_id =
order by sortorder
帮助 我认为,问题在于:
public function getChildLinks()
{
$list = array();
$WHERE_path = substr($_SERVER[ REQUEST_URI ], 1);
$WHERE_path = strlen($WHERE_path) ? = " .$WHERE_path. " : IS NULL ;
$parentPageRowset = Axl_Db::query( SELECT id, parent_id FROM .$this->_name. WHERE path .$WHERE_path);
$parent_id = $parentPageRowset[0][ parent_id ] ? $parentPageRowset[0][ parent_id ] : $parentPageRowset[0][ id ];
$listRowset = new Axl_Db_Rowset( SELECT path, title FROM .$this->_name. WHERE parent_id = .$parent_id. ORDER BY sortorder );
while($listRowset->next())
{
$list[ / .$listRowset->path] = $listRowset->title;
}
return $list;
}
This is the function causing the problem.