mysql_update()

int mysql_update

(

)

                  {
   char *query = "update runinfo set elapsed=%f where runid=%d";
   char* sql;

   sql = (char*) malloc(512*sizeof(char));
   open_connection();
   logger(LOG_DEBUG,"opened connection\n");

   sprintf(sql,query,rundetails->elapsed,mysqlinfo->runid);
   logger(LOG_DEBUG,"executing query %s\n",sql);
   if(mysql_query(connection,sql)){
     printf("%s\n",mysql_error(connection));
     return -1;
   }
   logger(LOG_DEBUG,"runinfo updated\n");

   free(sql);
   close_connection();

   return 1;
}