in reply to Sorting
(Season with spaces and linebreaks to taste.)while(@row = $sth->fetchrow) { ($vprofilenumber, $vStatus, $vPricePlusProduct, $vKeywords, $vUsername) = @row; print ... ... }
If that is comfortable, you can go a step further and eliminate the intermediate @row array entirely:
while( ($vprofilenumber, $vStatus, $vPricePlusProduct, $vKeywords, $vUsername) = $sth->fetchrow) { print... ... }
|
|---|