Thread: Help w/ mysql++ function

Hello -

This is my first remotely useful win32 app and I'm having some issues...

The program simply connects to a MySQL database and displays the results in a ListBox. However, the function I am using to do this is crashing the program at run-time.

Code:

int DoMysqlStuff(HWND hwndDlg)
{
	const char* host = "localhost";
	const char* username = "xp";
	const char* password = "*****";
	const char* database = "nazgul_db";
	MYSQL *conn;

	conn = mysql_init(NULL); 
	if(mysql_real_connect(conn, host, username, password, 
		database, 0, NULL, 0)) {
		const char *success = "Connected!";
		SendDlgItemMessage(hwndDlg, IDC_LISTDB, LB_ADDSTRING, 0, (LPARAM) success);
	}
	// create vars to get a result and a row pointer from DB 
	MYSQL_RES *result_set; 
	MYSQL_ROW row; 
	unsigned int i; 
 
	mysql_query(conn, "SELECT id,name,level FROM guild_members"); 
	result_set = mysql_store_result(conn); 
 
	if (!result_set) { 
		MessageBox(NULL, "Error storing result\n", "Error", MB_OK); 
		return -1; 
	} 
 
	// find out how many rows there will be 
	unsigned int numrows = mysql_num_rows(result_set); 

	while ((row = mysql_fetch_row(result_set)) != NULL) { 
		SendDlgItemMessage(hwndDlg, IDC_LISTDB, LB_ADDSTRING, 0, (LPARAM)(row[i] != NULL ? row[i] : "NULL"));
	}

	mysql_close(conn); 
	return 0;
}

I think the error is somewhere in the while() loop - I really don't know what it is though?

Any help would be appreciated,

Thank you

- rednax

Where is the value of i set? Most compilers should give you a warning.