Hi, I'm building a C API MySQL client. I need to connect to different dbs at the same time. My code is (approximately): //============================ MYSQL mysql, *conn1, *conn2; mysql_init(&mysql) conn1 = mysql_real_connect(&mysq, ip1, user1, pass1, db1, 0, NULL, 0) printf("conn1 = %d", conn1); conn2 = mysql_real_connect(&mysq, ip2, user2, pass2, db2, 0, NULL, 0) printf("conn2 = %d", conn1); conn3 = mysql_real_connect(&mysq, ip3, user3, pass3, db3, 0, NULL, 0) printf("conn3 = %d", conn3); // ... use conn1 // ... use conn2 // ... use conn3 mysql_close(conn1); mysql_close(conn2); mysql_close(conn3); mysql_close(&mysql); //============================ I see always that (conn1 == conn2 == conn3), so the prevuoius connection are overwritten. Could you give some explanation about this? How can I mantain different connections on different db (or different ip, user, etc....)? Thanks ================================================================== Valerio Ferrucci Tabasoft Sas [EMAIL PROTECTED] http://tabasoft.ancitel.it [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php