error in connecting to mysql using C program

[fivestaar]

Hi all

I am trying to access mysql through a c program, bt am stuck with a specific error. I have searched the net for solutions, but nothin helped

Code:



/* Simple C program that connects to MySQL Database server*/
#include <mysql.h>
#include <stdio.h>

main() {
MYSQL *conn;
MYSQL_RES *res;
MYSQL_ROW row;

char *server = "localhost";
char *user = "root";
//set the password for mysql server here
char *password = ""; /* set me first */
char *database = "mysql";

conn = mysql_init(NULL);

/* Connect to database */
if (!mysql_real_connect(conn, server,
user, password, database, 0, NULL, 0)) {
fprintf(stderr, "%s\n", mysql_error(conn));
exit(1);
}

/* send SQL query */
if (mysql_query(conn, "show tables")) {
fprintf(stderr, "%s\n", mysql_error(conn));
exit(1);
}

res = mysql_use_result(conn);

/* output table name */
printf("MySQL Tables in mysql database:\n");
while ((row = mysql_fetch_row(res)) != NULL)
printf("%s \n", row[0]);

/* close connection */
mysql_free_result(res);
mysql_close(conn);
}

The command i used to compile the program is:
gcc -o connectsql $(mysql_config --cflags) connectsql.c $(mysql_config --libs)

Error:
/tmp/ccx4qAGm.o: In function `main':
connectsql.c: (.text+0x13f): undefined reference to`mysql_free_results'
collect2: ld returned 1 exit status

[spjackson]

Error:
/tmp/ccx4qAGm.o: In function `main':
connectsql.c: (.text+0x13f): undefined reference to`mysql_free_results'
collect2: ld returned 1 exit status
The code you have posted has mysql_free_result (singular correct) but the error message has mysql_free_results (plural incorrect). Are you sure that the code you are compiling has mysql_free_result not mysql_free_results?

[manodo89]

While you have included the mySQL header files in your code, you haven't included the mySQL library in your link options.
internet marketing tips and strategy (http://internetmartketingpage.com/)
effective internet marketing (http://internetmartketingpage.com/)

[fivestaar]

The code you have posted has mysql_free_result (singular correct) but the error message has mysql_free_results (plural incorrect). Are you sure that the code you are compiling has mysql_free_result not mysql_free_results?

@spjackson thanks for pointing that out.
I checked my program n there were some typing errors, Helped me solve the prob. SO silly of me to over look it:oops:#-o