whats wrong in my code or compile method my code is here?

#include <stdio.h>
#include <stdlib.h>
#include "mysql.h"

MYSQL mysql;
MYSQL_RES *res;
MYSQL_ROW row;

void exiterr(int exitcode)
{
fprintf( stderr, "%sn", mysql_error(&mysql) );
exit( exitcode );
}

int main()
{
uint i = 0;

if (!(mysql_connect(&mysql,"host","username","password")))
exiterr(1);

if (mysql_select_db(&mysql,"ksedata"))
exiterr(2);

if (mysql_query(&mysql,"SELECT name,rate FROM emp_master"))
exiterr(3);

if (!(res = mysql_store_result(&mysql)))
exiterr(4);

while((row = mysql_fetch_row(res))) {
for (i=0 ; i < mysql_num_fields(res); i++)
printf("%sn",row[i]);
}

if (!mysql_eof(res))
exiterr(5);

mysql_free_result(res);
mysql_close(&mysql);
}


***************************************
when i compile above code following error messages come

undefined reference error mysql_connect(...)
undefined reference error mysql_bin(..)
etc...
whats wrong either my gcc is not link whith
client side lib or something else?
thanks in advance..

What do your compiling and linking commands look like?

Did you pass the the mysql.h header file argument and client library argument in the compiling and linking steps, respectively so the compiler and linker can find the files?

Try something like....

gcc -c -I/usr/local/include/mysql program.c

gcc -o program program.o -L/usr/local/lib/mysql -lmysqlclient