mySQL in C++

[B A]

hi,
I have the following code in my C++ program:

query_state = mysql_query(connection, "select * from cplpl");

wherein my cplpl table has 2 columns, a name and a balance.

However, when I run the program, it only shows all the records of the first column (I tried a few different tables with more columns as well, and for them also, it only returns the records in the first column), whereas when I run the same command from the mysql>, it shows all the records of all columns as I would have expected it to.

Can you please help me fix this...thx!