int main(int argc, char *argv[])
{
 
   char string1[1600], string2[1600], query[1600], query1[1600], mobileno[50];
   int i, j, len;
   FILE *fp2;
 
 
   mysql_init(&conn);
 
   /* Connect to database */
   if (!mysql_real_connect(&conn, host, user, password, database, 0, NULL, 0)) {
      fprintf(stderr, "%s\n", mysql_error(&conn));
      exit(0);
   }
 
/* send SQL query */
 
   bzero(query1, sizeof(query1));
   sprintf(query1, "select a.CreateDate, a.MobileNumber, b.BillName, b.CorrName, b.ICNew, b.ICOld, b.Passport,"
   "b.Addr, b.Addr2, b.Addr3, b.Addr4, b.Postcode, b.CountryCode from Register as a, Profile as b"
   " where a.MasterNumber = b.Number and a.Status=0");
 
   printf ("%s\n",query1);
 
   if (mysql_query(&conn, query1))
   {
        fprintf(stderr, "%s\n", mysql_error(&conn));
        exit(0);
   }
 
 
   res = mysql_use_result(&conn);
 
 
   /* output fields 0, 1 and 2 of each row */
   while ((row = mysql_fetch_row(res)) != NULL)
   {
      if (i==11)
      {
        timebuffer();
        i=1;
        bzero(string1, sizeof(string1));
      }
      else
      {
         sprintf(string1,"%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s", 
row[0], row[1], row[14], row[15], row[16], row[17], row[18], row[4], 
row[5], row[6], row[7], row[12], row[13]);
sprintf(mobileno,"%s", row[1]);
printf ("%s\n",string1);
 
        printf ("Test: %s\n",mobileno);
        writeLogFile(string1, mobileno);
        i++;
      }
 
/* Release memory used to store results and close connection */
   mysql_free_result(res);
   mysql_close(&conn);
 
   return 0;
}
 
    }

sprintf(query1, "select a.MobileNumber, b.BillName, b.ICNew, b.Passport,"
   "b.Addr, b.Addr2, b.Addr3, b.Addr4, b.Postcode, b.CountryCode, a.CreateDate, a.Source from Register as a, Profile as b"
   " where a.MasterNumber = b.Number and a.Status=0");
 
   //printf ("%s\n",query1);
 
   if (mysql_query(&conn, query1))
   {
        fprintf(stderr, "%s\n", mysql_error(&conn));
        exit(0);
   }
 
 
   res = mysql_use_result(&conn);
 
 
   /* output fields 0, 1 and 2 of each row */
   while ((row = mysql_fetch_row(res)) != NULL)
   {
      if (i==11)
      {
        timebuffer();
        i=1;
        bzero(string1, sizeof(string1));
      }
      else
      {
       escapeSpecialChar(row[2]);
 
       strcpy(var1,row[9]);
       if ( strcmp(var1,"MAL" ) == 0 )
       {
        strcpy (var1, "MALAYSIA");
          strcpy(var2, var1);
       }
 
       DB2date(row[10]);
 
         sprintf(string1,"%s|%s|%s|%s|%s,%s|%s,%s|%s|%s|%s|%s|", 
       row[0], row[1], row[2], row[3], row[4], row[5], row[6], row[7], row[8], var2, newDate, row[11]);
         sprintf(mobileno,"%s", row[0]);
       printf ("%s\n",string1);
 
      //printf ("Test: %s\n",mobileno);
        writeLogFile(string1, mobileno);
        i++;
      }
    }

void writeLogFile(char line2[1600], char* MobileNo)
{
    char * mobile = "0192426699";
    //char * mobile = MobileNo;
      mobile = MobileNo;
 
    FILE *fp;
    FILE *fp2;
    char len[255];
    char filename[255];
     int min;
    int hour;
    int day;
    int mon;
        int yr;
        time_t tvec = time(0);
        struct tm* dtime;
 
        //time(&tvec);
        dtime = localtime(&tvec);
 
    min = dtime->tm_min  ;
    hour = dtime->tm_hour  ;
    day = dtime->tm_mday  ;
        mon = dtime->tm_mon + 1 ;
        yr = dtime->tm_year  +1900;
 
    sprintf(filename,"twop_%04s""%02d""%02d""%02d""%02d"".dat",yr,mon,day,hour,min);
 
       // Filename Format twop_yyyyMMddhhmm.dat 
 
 
            fp=fopen(filename, "a+");
 
                  if ( (fputs(line2, fp)) == EOF) 
          {
                      printf("error write...");
          }
 
                  if ( (fputs("\n", fp)) == EOF) 
          {
                      printf("error write1...");
                  }
 
        //printf ("Test2: %s\n",mobile);
        UpdateStatus(mobile, line2);
            bzero(line2, strlen(line2));
            strcpy (line2, "1");
 
            fclose(fp);      
}

0135712114|MALIK BIN JANG|68100311355821||171, JLN KAMPUNG SERPAN LAUT,KAMPUNG SERPAN LAUT,|94600 ASAJAYA,|94600|MALAYSIA|05-12-2006|1|
Segmentation fault