Aug 7, 2015, 7:47 AM
Add these 2 use statements (which should be in EVERY script) to the beginning of the script just after the shebang line.
Re: [newera] MySQL query problem
Those pragmas will point out lots of common coding mistakes/errors.
The strict pragma will require you to declare your vars, which is done with the my keyword.
There are a number of problems with your code. To begin with, neither of the while loops do anything with the fetched values in the @row array, which makes them pointless.
The only thing those loops do is to repeatedly assign some variables the same value and those values have nothing to do with the fetched rows.
(This post was edited by FishMonger on Aug 7, 2015, 7:48 AM)