Programming

#include <stdio.h>
#include <fcntl.h>
#include <signal.h>
#include <unistd.h>
#include <mysql.h>
#include <string.h>
#include <stdlib.h>
#include <sys/time.h>
#include <mysql.h>

int main(int argc, char **argv)
{

   MYSQL *conn;
        MYSQL_RES *result;
        MYSQL_ROW row;
        MYSQL_FIELD *field;
        int num_fields;

          conn = mysql_init(NULL);
          mysql_real_connect(conn, "localhost", "biduser", "biduser1234", "bid", 0, NULL, 0);

         mysql_query(conn, "select * from site_auth where user_admin='admin' ");
         result=mysql_use_result(conn);

         num_fields=mysql_num_fields(result);
         printf("Total fields= %d\n",num_fields);

        while(row=mysql_fetch_row(result))
        {
                 printf("%s",row[0]);
                 printf("%s",row[1]);
                 printf("%s",row[2]);
                 printf("%s",row[3]);
                 
                int getrow=row[0];

                if(getrow=='1'){
                        printf("\n admin");
                }
        }


   mysql_free_result(result);
   mysql_close(conn);
}

siteauth_id    user_admin   password_admin                                   comment
1                  admin           c92b51b2f4d93d4e1081670bd9273402    Administrator
769204065    demouser    81dc9bdb52d04dc20036dbd8313ed055    demo