EXEC SQL SET DATABASE DB1 = "example:localhost:user:passw";
EXEC SQL CONNECT DB1;
EXEC SQL BEGIN DECLARE SECTION;
     BASED ON table1.id my_id;
EXEC SQL END DECLARE SECTION;

MYSQL_RES *result;
 EXEC SQL SELECT id INTO :my_id FROM name_db;
 result = mysql_store_result(&mysql);

 if(result != NULL)
 {
  numofrows = mysql_num_rows (result);
  printf ("--\n", numofrows);
  }
  else {printf ("--\n"); break;}
 mysql_free_result (result);
 mysql_close (&mysql);
    return 0;
}