Hello,
Does sombody know what could be wrong with the following code:
It compiles alright but when i run the binary file it give's a Segmentation fault.
GreetzCode:#include "/usr/local/mysql/include/mysql/mysql.h" #include <stdio.h> #include <string.h> main() { MYSQL *subconn; MYSQL *domeinconn; MYSQL_RES *sub; MYSQL_RES *domein; MYSQL_ROW subrow; MYSQL_ROW domeinrow; char *server = "xxx"; char *user = "xxx"; char *password = "xxx"; char *database = "xxx"; subconn = mysql_init(NULL); domeinconn = mysql_init(NULL); if (!mysql_real_connect(subconn, server, user, password, database, 0, NULL, 0)) { fprintf(stderr, "%s\n", mysql_error(subconn)); exit(0); } if (!mysql_real_connect(domeinconn, server, user, password, database, 0, NULL, 0)) { fprintf(stderr, "%s\n", mysql_error(domeinconn)); exit(0); } /* send SQL query */ if (mysql_query(subconn, "SELECT * FROM table1")) { fprintf(stderr, "%s\n", mysql_error(subconn)); exit(0); } sub = mysql_use_result(subconn); domein = mysql_use_result(domeinconn); while ((subrow = mysql_fetch_row(sub)) != NULL) { if(mysql_query(domeinconn, "SELECT domein_naam FROM table2 WHERE domein_id=3")) { fprintf(stderr, "%s\n", mysql_error(domeinconn)); exit(0); } while ((domeinrow = mysql_fetch_row(domein) != NULL) { printf("%s%s\n", domeinrow[0], subrow[2]); } } mysql_close(domeinconn); mysql_close(subconn); }



LinkBack URL
About LinkBacks


