Re: How can I get the last element of an array inside of fetchall

Your 2 examples have slightly different logic. In your first example (with the database) you are pushing and printing inside the loop. In your second example you are pushing inside the loop but printing outside it. This explains the difference in the outputs you are seeing.

🦛

Comment on Re: How can I get the last element of an array inside of fetchall_arrayref?

Replies are listed 'Best First'.
Re^2: How can I get the last element of an array inside of fetchall_arrayref? by Lewisa (Novice) on Mar 23, 2021 at 17:57 UTC
Hey Hippo. Thank you! You are correct, I missed that error on my end. However, how can I print inside of the fetchall_arrayref loop and still get the last element, 3? All of my data is connected within that loop and the second I leave the loop they're no longer connected, correct?	[reply]
Re^3: How can I get the last element of an array inside of fetchall_arrayref? by hippo (Archbishop) on Mar 23, 2021 at 18:45 UTC
Your variables (scalars and arrays in this case) which are declared outside the loop will continue to hold their values once the loop is finished - just like they do in your second example. Try it and see! Scoping is an important topic in programming generally, not just in Perl. It will be worth your time to read and learn more about it. The usual reference given is Coping with scoping which covers lots more than you will need for this particular question - but it is all good stuff. 🦛	[reply]
Re^4: How can I get the last element of an array inside of fetchall_arrayref? by Lewisa (Novice) on Mar 23, 2021 at 20:09 UTC
Thanks a lot! I will read that top to bottom as I thought I understood scope but I'm clearly missing a few key points.	[reply]
Re^4: How can I get the last element of an array inside of fetchall_arrayref? by Lewisa (Novice) on Mar 24, 2021 at 01:20 UTC
Hey Hippo. I thought that I responded to your comment. Thank you! I thought I had a great understand of scope but I see that I'm missing a few key points. I will be reading that link you posted.	[reply]