Thread: mysql database to listbox

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.

Hi Salem,

TEXT("%S") works!!!

Thank you !