C Segmenation fault

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.

Code:

---

#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);
}

---

Greetz

Try compiling it with the -g option and then when it seg faults and dumps a core you can use gdb to see which line it's crashing on.

Store result before reading from it.

Code:

---

        if(mysql_query(domeinconn, "SELECT domein_naam FROM table2 WHERE domein_id=3")) {
                fprintf(stderr, "%s\n", mysql_error(domeinconn));
                exit(0);
        }

        domein = mysql_use_result(domeinconn);

        while ((domeinrow = mysql_fetch_row(domein) != NULL) {
                printf("%s%s\n", domeinrow[0], subrow[2]);
        }

---

> while ((domeinrow = mysql_fetch_row(domein) != NULL)
Since this doesn't even compile (mismatched parens), we've no idea whether this is your real code or something you just managed to post by pressing random keys.

> printf("%s%s\n", domeinrow[0], subrow[2]);
Validate the call to make sure those array elements exist before you try and access them