//Nomal Query - this works :) $query = "SELECT SQL_CALC_FOUND_ROWS * FROM pp_files WHERE `approved` = '1' AND `feature` = '1' AND `reject` = '0' LIMIT %d,%d "; $_query = sprintf($query, SmartyPaginate::getCurrentIndex(), SmartyPaginate::getLimit()); //Search Query - This doesnt work but i do know know why $query = "SELECT SQL_CALC_FOUND_ROWS * FROM pp_files WHERE `name` like '%$_POST[searching]%' LIMIT %d,%d"; $_query = array_slice($query , SmartyPaginate::getCurrentIndex(), SmartyPaginate::getLimit());