MySql C API запросы

// ----- include begin -----
#include <mysql.h>
#include <stdio.h>
#include "confuse.h"
// ----- include end -----
 
int main(void) {
 
// ----- data block begin -----
    MYSQL *conn;
    MYSQL_RES *res;
    MYSQL_ROW row;
// ----- data block end -----
 
// ----- connect and initialisation to database block begin -----
    conn = mysql_init(NULL); 
 
    if (conn == NULL) 
    {
        printf("Error %u: %s\n", mysql_errno(conn), mysql_error(conn));
        exit(1);
    }
 
    if (!mysql_real_connect(conn, server, user, password, database, port, NULL, 0))
    {
        fprintf(stderr, "%s\n", mysql_error(conn));
        exit(1);
    }
// ----- connect and initialisation to database block end -----
 
// ============= main SELECT query ===================
 
if (mysql_query(conn, "SELECT id,ip,mac,status FROM user WHERE router= '1'"))
    {
        fprintf(stderr, "%s\n", mysql_error(conn));
        exit(1);
    }
 
// ----- strore result -----
    res = mysql_store_result(conn); 
// ----- store result -----
 
// =================== main cycle for rules =====================
    while ((row = mysql_fetch_row(res)) != NULL)
    {
// ----- print status -----
       printf("%s", row[3]); 
// ----- print status -----
 
// --------------- delete row from table client by id if status = 8 ----------------
    if (atoi(row[3]) == 8)
    {
        if (mysql_query(conn, "DELETE FROM user WHERE id ='row[0]'"))
        {
            fprintf(stderr, "%s\n", mysql_error(conn));
            exit(1);
        }
    }                                                              
// --------------- delete row from table client by id if status = 8 ----------------
    } // while
    mysql_free_result(res)
// =================== main cycle for rules =====================
// ============= main SELECT query ===================
    mysql_close(conn); // close mysql connection
 
  return 0; // return
}

if (atoi(row[3]) == 8)
{
        sprintf(buff, "DELETE FROM user WHERE id='%s'",row[0]);
        if (-1==mysql_query(conn, buff))
        {
                fprintf(stderr, "%s\n", mysql_error(conn));
        }
}