100 order by nombre desc"; $rows = DB::getBySQL($sql); foreach ($rows as $row) { $numberToDelete = $row->nombre - 200; // on laisse 100 $sql = "delete from chat_messages WHERE webmasterid=$row->webmasterid ORDER BY id LIMIT $numberToDelete"; echo "$sql\r\n"; DB::executeSQL($sql); } //$sql = "DELETE from chat_messages WHERE data < NOW() - INTERVAL 7 DAY"; //DB::executeSQL($sql);