mysql select statement

hey all,

recently ive been trying to run mysql queries in c++. ive successfully connect to the database using the following code:

Code:

MYSQL mysql;
MYSQL *mysqlRtn;
mysql_init(&mysql);
mysql_options(&mysql, MYSQL_READ_DEFAULT_GROUP, "administrator");
mysqlRtn = mysql_real_connect(&mysql, "localhost", "root", "password", "administrator", 0, NULL, 0);

what am stuck on is how to do a select statement in c
for example:

SELECT * FROM <table>;

does anyone know how i can do this in c and return all the data in an array of sorts?

Thanks in advance.

Create a structure that represents a record.
Run your query, allocate enough room for an array of your structures, and fill in the array with the results. Return it. (Or use std::vector if you're using C++)

Ideally, look up the function in the documentation for your library. Something like mysql_query() perhaps?

Thanks i got it
use mysql_query() to run the query then use mysql_store_result() to retrieve the data.

i use mysql_use_result()
because it doesnt make an temporary table and runs faster... as long as you dont have to do a lot of calulations or table manipulation.

then you just need to fetch all the rows.
mysql_fetch_row()