Hello i really need help with this issue, my last console.log is execute BEFORE the for loop and i dont know how to fix it. I really need to have access at my array nbfilm after the for loop

Can someone help me?

What the console print : lien

client.db.query("SELECT name,id FROM film", function (err, result) {
        if (err) throw err;

          const catalog = new MessageEmbed()
            .setTitle("Catalogue")
            .setColor("#fcfe80")
            .setFooter({text:"