$sqlQuery = "SELECT `id`, `f3871` + 1 as orders_number FROM ".DATA_TABLE."131 WHERE `status` = 0 AND MONTH(`add_time`) = MONTH(CURDATE()) AND YEAR(`add_time`) = YEAR(CURDATE()) AND `id` != ".intval($line['ID'])." ORDER BY `id` DESC LIMIT 1"; $result = mysql_query($sqlQuery); if(mysql_num_rows($result) > 0) { $select_number = mysql_fetch_assoc($result); $line['Номер договора в текущем месяце'] = $select_number['orders_number']; } else { $line['Номер договора в текущем месяце'] = 1; }
Хватит работать по ночам. Поменял условие запроса.