Thread: how to reach MySQL??

hi everybody,
I have linux box, installed RedHat9, MySQL3.23.54, and gcc.
I want to reach MySQL database server, in C program .
So MySQL-devel also installed, and MySQL header files(mysql.h, mysql_version.h, mysql_com.h) seems under /usr/include/mysql)
but the when I compile the c program gives so many parse error refers to mysql.h and also says it could not found my_alloc.h..that mkes me grief as you guessed.
I wonder if anyone send me simple program that uses Mysql and explicit assertion how to use and configure MySQL header files and libraries. or is there any document expreses this matter in any dark room of the net??

any helps are apreciated.
best regards.
//metin


__________________

hi
most probably you are forgetting to use "-lmysqlclient" option to compile your program. (I assume that your mysql library files are located under the default directory for GCC)
here is a simple code for mysql

Code:

#include <stdio.h>
#include <mysql/mysql.h>

MYSQL sql;

int main()
{

 if (mysql_connect(&sql,"your_hostname","username","passwd"))
  {
    printf("OK\n");
    mysql_close(&sql);
  }
 else
  {
    fprintf(stderr,"Zong!!");
    exit(1);
  }

 return 0;
}

and finally, "sanýrým turkiye'densin "

Kolay gelsin....