//compile g++ mysql.C `mysql_config --cflags --libs` -o mysql
#include <iostream>
#include <mysql.h>
#include <my_global.h>
#include <ctime>

using namespace std;

MYSQL *connection, mysql;
MYSQL_RES *result, *result_time;
MYSQL_ROW row;
int query_state;

int main(){

  time_t t = time(0); 
  cout << "Time for now is: " <<  time((time_t*)localtime(&t)) << endl;

 mysql_init(&mysql);
 connection = mysql_real_connect(&mysql, "dq5cmd.inp.nsk.su", "daqread", "daqread", "online", 3306, 0, 0);
 mysql_query(&mysql, "select * from RunparOff where name='bhrawamp' order by run desc limit 20");
 result = mysql_store_result(&mysql);
 mysql_query(&mysql, "select * from RunparOff where name='time' order by run desc limit 20");
 result_time = mysql_store_result(&mysql);
 //mysql_query(&mysql, "DESCRIBE RunparOff");
 

if(mysql_num_rows(result) > 0)
  {

  while (row = mysql_fetch_row(result))
  {
  cout << row[0] << " " << mysql_fetch_row(result_time)[3] <<  " " << row[3] << "  " << row[4] << endl;
}
}
else
{
  cout << "Не найдено ни одной статьи этого автора";
}

return 1;
}