/*ex6.c*/
#include <stdlib.h>
#include <stdio.h>
#include  <mysql/mysql.h>
MYSQL my_connection;
MYSQL_RES *res_ptr;
MYSQL_ROW sqlrow;
void display_row(MYSQL *ptr);
int main()
{
   int res;
   mysql_init(&my_connection);
   if (mysql_real_connect(&my_connection, "localhost", "test","test", "testdb", 0, NULL, 0))
   {
  printf("Connection success\n");
  res = mysql_query(&my_connection, "SELECT childno, fname,  age FROM children WHERE age > 5");
        if (res)
  {
          printf("SELECT error: %s\n", mysql_error(&my_connection));
    return -2;
  }
  else
  {
     res_ptr = mysql_use_result(&my_connection);
     if (res_ptr)
    {
      printf("Retrieved %lu rows\n",(unsigned long)mysql_num_rows(res_ptr));
      while ((sqlrow = mysql_fetch_row(res_ptr)))
      {
           printf("Fetched data...\n");
        display_row(&my_connection);
      }
           if (mysql_errno(&my_connection))
      {
         fprintf(stderr, "Retrive error: s\n",mysql_error(&my_connection));
         return -3;
             }
             }
            mysql_free_result(res_ptr);
         }      
           mysql_close(&my_connection);
    printf("Connection closed.\n");
  }
  else
  {
    fprintf(stderr, "Connection failed\n");
    if (mysql_errno(&my_connection))
    {
       fprintf(stderr, "Connection error %d: %s\n",
        mysql_errno(&my_connection),mysql_error(&my_connection));
  return -1;
     }
  }
  return 0;
}

void display_row(MYSQL *ptr)
{
  unsigned int field_count;
  field_count=0;
  while(field_count<mysql_field_count(ptr))
  {
    printf("%s ",sqlrow[field_count]);
    field_count++;
  }
  printf("\n");
}

g++ -g     -o test_server  test.c  -lnsl -I/usr/local/mysql/include/ -L/usr/local/mysql/lib/ -lmysqlclient  -lz