[WIN32] Printing MySQL results

[publikum]

I'm writing a Win32 application that uses MySQL C API...(package MySQL for DevC++)...

I got the connection, I can execute queries, but I don't know how to display results from a query(in main window)...?

thanks for help!

[Codeplug]

Either make your application a console window and use std::cout,

or

http://www.winprog.org/tutorial/

gg

[publikum]

I managed to print the results into Listbox in a Dialog, but I've got few problems:

1. If I only select ID from query, I've got about 7 lines for each row (some weird characters) and only one is ID.

2. I can't use characters, used in windows-1250 encoding (characters are replaced by sings like ® © and so on....).

Thanks for help in advance...

Part of code:

 
char *query;
query = "SELECT id FROM table";
mysql_query(&mysql, query);
result = mysql_store_result(&mysql);
num = mysql_num_rows(result);
while((row = mysql_fetch_row(result)))
{
	UINT length;
	length = (UINT)mysql_fetch_lengths(result);
	for(UINT i = 0; i < num; i++)
	{
	 SendDlgItemMessage(hwnd, IDC_LST1, LB_ADDSTRING, 0, (LPARAM)row[i]);
	}

[Kleid-0]

char *query;
query = "SELECT id FROM table";
mysql_query(&mysql, query);
result = mysql_store_result(&mysql);
num = mysql_num_rows(result);
while((row = mysql_fetch_row(result))) // What's the datatype for the variable "row"?
{
    UINT length;
    length = (UINT)mysql_fetch_lengths(result);
    for(UINT i = 0; i < num; i++)
    {
     SendDlgItemMessage(hwnd, IDC_LST1, LB_ADDSTRING, 0, (LPARAM)row[i]);
    }

[publikum]

It's MYSQL_ROW...

But never mind...I figured out

[Kleid-0]

Wait! No! What was the answer?

[publikum]

 
mysql_real_query(&mysql, query, strlen(query));
result = mysql_store_result(&mysql);
num = (UINT)mysql_num_fields(result);
while(row = mysql_fetch_row(result))
{
	UINT *length;
	length = (UINT *)mysql_fetch_lengths(result);
	for(UINT i = 0; i < (UINT)num; i++)
	{
	 strncpy(data, row[i], (int)length[i]);
	 SendDlgItemMessage(hwnd, IDC_LST1, LB_ADDSTRING, 0, (LPARAM)row[i]);
	}
}