mysql_res=mysql_query(hMySQL,LPCSTR("SELECT * FROM table_name"));
hMySQlResult=mysql_use_result(hMySQL);
while(MySQLROW=mysql_fetch_row(hMySQlResult))
{
        
}
mysql_free_result(hMySQlResult);

mysql_res=mysql_stmt_prepare(hMySQL_STMT, LPCSTR("SELECT * FROM table_name"), sizeof("SELECT * FROM table_name"));
mysql_res=mysql_stmt_execute(hMySQL_STMT);
hMySQlResult=mysql_use_result(hMySQL); // результат hMySQlResult=NULL
while(MySQLROW=mysql_fetch_row(hMySQlResult))
{
        
}
mysql_free_result(hMySQlResult);