Hello, I'm trying to output my database to a listbox...
Code:
MYSQL *conn;
MYSQL_RES *result;
MYSQL_ROW row;
void Mysql_Server_Connect( HWND hWnd )
{
// create list box: to display database.
HWND hWnd_List1 = CreateWindow( TEXT("LISTBOX"), NULL, WS_CHILD|WS_VSCROLL|LBS_DISABLENOSCROLL|WS_VISIBLE|LBS_STANDARD, 360, 165, 290,290, hWnd, NULL, ghInstance, NULL);
conn = mysql_init(NULL);
mysql_real_connect(conn, "localhost", "root", "password", "mydatabase", 0, NULL, 0) ;
mysql_query(conn, "SELECT * FROM drivers");
result = mysql_store_result(conn);
TCHAR Buffer [50];
for (unsigned int i=0; i< mysql_num_rows(result); i++)
{
while( row = mysql_fetch_row(result) )
{
for (unsigned int k=0; k< mysql_num_fields(result); k++)
{
//unsigned long * lengths = mysql_fetch_lengths(result);
//wsprintf (Buffer, TEXT ("%lu"), lengths[k]);
//(const char*)SendMessage(hWnd_List1, LB_INSERTSTRING, 0,
(LPARAM)Buffer );
wsprintf (Buffer, TEXT ("%s"), row[k]);
(const char*)SendMessage(hWnd_List1, LB_INSERTSTRING, 0,
(LPARAM)Buffer );
}
}
}
mysql_free_result(result);
mysql_close(conn);
}
'%s'' doesn't seem to work,
what should I use here?
Thank you.