Samb i'm trying to understand what you want to do. About the invalid x,y value. This can be solved by programming while keeping that in mind. Anyways i'm going to try today.

Code:
#include <acknex.h>

//----------------------------------------------------------------------------
// DLL FUNCTIONS
//----------------------------------------------------------------------------
function mySQL_Connectdb(char* w,char* x,char* y,char* z);
function mySQL_Closedb();
function mySQL_ExecQuery(string);
function mySQL_GetVal(x, y);
function mySQL_GetStr(string,x,y);
function mySQL_RowNumber();
function mySQL_IsConnected();

//----------------------------------------------------------------------------
// VARIABLES
//----------------------------------------------------------------------------

var mysql_handle_n;
var rxrownr;

//----------------------------------------------------------------------------
// STRINGS
//----------------------------------------------------------------------------

STRING* MyAppTitle;
STRING* MyConnection = "#80";
STRING* MyQuery      = "#255";

//----------------------------------------------------------------------------
// FONTS
//----------------------------------------------------------------------------

FONT* standard_font = "ackfont.pcx";
FONT* digit_font    = "digfont.pcx";

//----------------------------------------------------------------------------
// PANELS
//----------------------------------------------------------------------------

PANEL* demo_logo =
{
  layer = 1;
  bmap = "logo.tga";
  flags = VISIBLE;
}

PANEL* rxrownr_panel =
{
  layer = 2;
  digits(15,75,"Row in dataset:",standard_font,0,0);
  digits(0,85,4,digit_font,1,rxrownr);
  flags = VISIBLE;
}

//----------------------------------------------------------------------------
// TEXT
//----------------------------------------------------------------------------

TEXT* connection_txt =
{
	layer  = 3;
	string = ("MySQL Server Status:", MyConnection);
	pos_x  = 15;
	pos_y  = 15;
	font   = standard_font;
	flags  = VISIBLE;
}

TEXT* query_txt =
{
	layer  = 4;
	string = ("MySQL Query:", MyQuery);
	pos_x  = 15;
	pos_y  = 40;
	font   = standard_font;
	flags  = VISIBLE;
}

//----------------------------------------------------------------------------
// HEART OF THE GAME
//----------------------------------------------------------------------------

function main()
{
	fps_max = 60;
	
	MyAppTitle = str_create("Lite-C MySQL A7.06.1");
	video_window(vector(0,0,0),NULL,112,MyAppTitle);
	video_set(640,480,32,2);
	
	mySQL_Connectdb(&"dbname",&"dbhost",&"dbadmin",&"dbpass");
	if(!mySQL_IsConnected())
	{
		str_cpy(MyConnection, "Connection closed");
		str_cpy(MyQuery, "unknown");
	}
	else
	{
	str_cpy(MyConnection, "Connection established");
	str_cpy(MyQuery, "SELECT * FROM players");
	}
	
	// Show the number of rows in players table
	if(mySQL_ExecQuery(MyQuery) && mySQL_RowNumber() >0)
	{
		rxrownr = mySQL_RowNumber(); // Return the number of rows
		wait(1);
	}
	
	while(1)
	{
		wait(1);
	}
	//mySQL_Closedb();
}


smile