http://www.perlmonks.org?node_id=1187268


in reply to Re^2: How to add columns with new row name using perl from mysql query?
in thread How to add columns with new row name using perl from mysql query?

Is it possible..

Yes

Without modifying while loop..

No ( unless you make the SQL more complex )

Note the error message for your select is still wrong here

$sth->execute() or print "Could not in7sert_run_pend data"; 
poj