Hi Carl,
thank you for your reply.
did you have a look at my original posting where I included the code?
your code (omitting the error routines) is essentially like this:
sock=mysql_init(0))
mysql_real_connect(sock,ipNumber,userName,password,gvDatabase,3306,NULL,0)
mysql_select_db(sock,gvDatabase)
// possibly looped
mysql_real_query(sock, query, strlen(query))
mysql_free_result(tableRes);
// eoloop
// At the end of the program, I close the socket.
> 1. I don't open a connection for each query, using the already open socket
> instead (good for some things, not good for other ones.)
>
> where in your code are you closing the connection?
I tried both: to embrace the query/free_result into mysql_init/mysql_close
commands within the loop as well as doing the mysql_init/mysql_close at the
beginning and at the end of the program. (just as you do and as I posted in
my first message)
> 2. You have to free the result set after every select.
I free the result set after every select until NULL.
hmmm...
anyway many thanks,
Ronny
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
