OK.. have to finally chime in... I managed to connect the DB without any problems... heres my code snippit:

Code:


	str_cpy(test_text.string[1], "Connecting to DB");
	sleep(1);
	
	var hr;
	hr = mySQL_Connectdb("dbname","localhost","root","password");
	if(hr == 1)
	{
		str_cpy(test_text.string[1], "DB is connected and online");
		sleep(1);
		mySQL_ExecQuery("use table01;");
	}
	else
	{
		str_cpy(test_text.string[1], "DB failed to connect");
		sleep(5);
		exit;
	}

	// get an entry from the DB
	str_cpy(test_text.string[1], "Performing query");
	sleep(1);
	hr = mySQL_ExecQuery("select * from table01 where name='index';");
	str_cpy(test_text.string[1], "Aquiring result");
	sleep(1);
	mySQL_GetStr(test_text.string[2],0,0);


At the moment, it crashes when I make the mySQL_GetStr(test_text.string[2],0,0); call.

test_text is a text object just for displaying some results and includes a couple of strings. Everything works up untill I try to extraxt info from the resultset (which I'm assuming is being returned as part of the query?). I've tried using 0, 1, and mySQL_RowNumber() for the third peram... Since 'index' is the first field in the DB row, I expected it to return exactly what I put out to the query.

So, the question is... now that I can connect, and seemingly access the table... how do I extract info from the DB?

Just thinking out loud, Specterdragon