title: C running query shows command out of sync?
body: <p>We are running a C program where for every one second there is a function callback. Below is the snippet of the code listed:</p>
  
  <pre><code>char timeBuf[10],secondBuf1[100],queryBuf1[500],queryBuf2[500];
  char buff[20] = {0};
  struct timeval tv;
  gettimeofday (&amp;tv, NULL);
  tv.tv_sec -= 5;
  strftime(buff, 20, "%Y-%m-%d %H:%M:%S", localtime(&amp;tv.tv_sec));
  printf("\nTime is %s", buff);
  
  sprintf(secondBuf1,"INSERT INTO  secondsLog2 (secondLogID , timeStampID ) VALUES (NULL,'%s')",buff);
  //printf("Query 1 before executing %s\n",queryBuf1);
  if (mysql_query(localConn, secondBuf1)) 
  {
      printf("Error in insert of seconds log %s\n",mysql_error(localConn));
      exit(1);
  }
  
  sprintf(queryBuf1,"SELECT ipDest, portDest, SUM(packetLen), COUNT(ipDest) FROM source1 WHERE timeStamp = '%s' GROUP BY portDest",buff);
  printf("\nQuery buf %s",queryBuf1);
  if(mysql_query(remoteConn, queryBuf1))
  {
      printf("Error in first query of select %s\n",mysql_error(remoteConn));
      exit(1);
  }
  localRes1 = mysql_use_result(remoteConn);
  while((localRow1 = mysql_fetch_row(localRes1)) !=NULL)
              {
                sprintf(queryBuf1,"INSERT INTO  export1 (iBTID ,timeStampID ,ipDest ,portDest,totalBits, packetCount) VALUES (NULL,'%s','%s','%s',%s,%s)",buff, localRow1[0],localRow1[1],localRow1[2],localRow1[3],localRow1[4]);
                printf("Query 1 before executing %s\n",queryBuf1);
                if (mysql_query(localConn, queryBuf1)) 
                {
                  printf("Error in first query of insert %s\n",mysql_error(localConn));
                   exit(1);
                }
  
              }
                          mysql_free_result(localRes1);
  </code></pre>
  
  <p>The moment I run this script the second <code>SELECT</code> will give me this error: <em>Commands out of sync; you can't run this command now</em>:</p>
  
  <pre><code>Time is 2012-07-17 00:59:14
  Query buf SELECT ipDest, portDest, SUM(packetLen), COUNT(ipDest) FROM source1 WHERE timeStamp = '2012-07-17 00:59:14' GROUP BY portDest
  Time is 2012-07-17 00:59:15
  Query buf SELECT ipDest, portDest, SUM(packetLen), COUNT(ipDest) FROM source1 WHERE timeStamp = '2012-07-17 00:59:15' GROUP BY portDestError in first query of select Commands out of sync; you can't run this command now
  </code></pre>