I require repair an expert advisor to take and close positions from a MySQL server table

I require an expert advisor to take and close positions from a MySQL server table, the idea is: from a table of positions available in MySQL server, the expert advisor connect and consume this to open and close positions, continuously, with more details :

The table is arranged in MySQL server contains the following fields :

1) Order_id : an identifier of the order is taken

2) pair_name : symbol eg EURUSD parity

3) TIME_ID : minute registration time and date in which to take the position

4) ammount : Number of items to put in the position

5 ) sl : stop loss

6) tp : yake profit

7) state: the state of the position is open or closed

8) ticket: Ticket registration platform that is thrown when a position is taken

9) mode_id Identifies the model from which the position was defined .



fields 1 , 2, 3 , 4, 5 , 6 and 9 will be completed based on the work of modeling with other packages , but the fields 7 and 8 will be completed by the expert advisor , it is important to clarify that the table must feed every minute , so that few second after the table is updated in their fields 1-6 and 9 (which is done every 60 seconds ), the expert advisor must complete the fields 7 and 8 should also do so every 60 seconds . With the above table for each record contains an order to buy or sell .

Importantly, a position must be closed (apart from reaching the SL or TP ) through an opposite order , ie if at first an order to buy is thrown and misses the SL or TP , and the next minute the table adds another record amount of same parity and generate an effect of closing the position initially taken .

i have a code, but dont work.