#include "stdafx.h"
#include <iostream>
#include <algorithm>
#include <functional>
#include <vector>
#include <ctime>
#include <cstdlib>
#include <windows.h>
#include <mysql.h>
#include <sstream>
using namespace std;

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

int main () {
	while (true)
{
	mysql_init(&mysql);
		connection = mysql_real_connect(&mysql,"94.62.18.167","fortune","Sereoja","cpp_data",0,0,0);
		if (connection == NULL) {
			cout << mysql_error(&mysql) << endl;
			return 1;}


		query_state = mysql_query(connection,"SELECT extrasul FROM extrasele ORDER BY ID DESC LIMIT 1,1" );
		if (query_state !=0) {
			cout << mysql_error(connection) << endl;
			return 1;}

result = mysql_store_result(connection);
while ( ( row = mysql_fetch_row(result)) != NULL ) {
cout << "Numarul Extras: " <<row[0] << endl;
}

Sleep(60000*5); //5 minutes
		cout<< "\n";


	}
    	}