$query = "SELECT a.*, cc.name AS category, dd.ezcity AS proploc, ee.name AS statename, ff.name AS cnname, ss.dealer_name AS propseller, u.name AS editor"
. "\n FROM #__ezrealty AS a"
. "\n LEFT JOIN #__ezrealty_catg AS cc ON cc.id = a.cid"
. "\n LEFT JOIN #__ezrealty_locality AS dd ON dd.id = a.locid"
. "\n LEFT JOIN #__ezrealty_state AS ee ON ee.id = a.stid"
. "\n LEFT JOIN #__ezrealty_country AS ff ON ff.id = a.cnid"
. "\n LEFT JOIN #__ezrealty_profile AS ss ON ss.mid = a.owner"
. "\n LEFT JOIN #__users AS u ON u.id = a.checked_out"
. ( count( $where ) ? "\n WHERE " . implode( ' AND ', $where ) : "")
. if ( isset ($_POST['idSearch']) )
. { " WHERE a.id = " . $_POST['idSearch'] ; }
. "\n ORDER BY ". $order
. "\n LIMIT $pageNav->limitstart, $pageNav->limit"
;
я не понимаю здесь неправильный синтаксис :( ,, и он продолжает возвращать ту же ошибку, неожиданную T_IF
. (!empty($_POST['idSearch']) ? " WHERE a.id = " . $_POST['idSearch'] : "\n ORDER BY ". $order ."\n LIMIT $pageNav->limitstart, $pageNav->limit");
Это правильное решение для поиска на всех страницах, а не только на отображаемой. - person omnia Mm   schedule 22.12.2011