getting a (.text+0x18): undefined reference to 'main'

[jam]

i'm getting the above error when i try to compile this simple program that's attempting to test out embedded mysql:

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

int main(void)
{
	MYSQL msyql;
	MYSQL_ROW row;
	MYSQL_RES *result;

	unsigned int num_fields;
	unsigned int i;

	mysql_init(&mysql);

	if(!mysql_real_connect(&mysql,"192.168.1.100","root","password","db",o,NULL,o))
	{
		fprintf(stderr,"Failed to connect to database: Error: %s\n",
			mysql_error(&mysql));

	}
	else
	{
		if(mysql_query(&mysql,"SELECT * FROM table"));
//		error
		else
		{
			result = mysql_store_result(&mysql);
			num_fields = mysql_num_fields(result);
			while(row = mysql_fetch_row(result))
			{
				unsigned long *lengths;
				lengths = mysql_fetch_lengths(result);
				for(i=0; i < num_fields; i++)
				{
					printf("[%.*s]\t",(int)lengths[i],row[i] ? row[i] : "NULL");
				}
				printf("\n");
			}
		}
	}
	return 0;
}

i'm using the following command to compile:

gcc -filename.c -g -o filename -L /usr/lib/mysql -lmysqlclient


any ideas? :S

[hk_mp5kpdw]

gcc -filename.c -g -o filename -L /usr/lib/mysql -lmysqlclient

Not familiar with gcc or compiling with the command line but that first '-' looks suspicious.

[cmay]

gcc  -o [executable] ./[filename.c]  -lmysql

this will be closer. i dont know how to link the mysgl library but it must say so somewhere in the documentation. as example if the math library should be included the you use the -lm switch just like that to link the math library. the commandline arguments giving in this case is most likely the problem.

[jam]

durrrr i'm stupid, i had the dash there and it shouldn't have been. thanks for pointing it out!

jam

[jam]

ok, more problems

this line is now giving me a seg fault:

result = mysql_store_result(&mysql);

and i'm not sure why!

any ideas?

[jam]

mmk, it seems that the reason i was getting a seg fault is that that line isn't working (&mysql isn't recieving the data from the DB) so when i try and do:

num_fields = mysql_num_fields(result);

there's nothing there and it seg faults. i've replaced it with:

if(!(result = mysql_store_result(&mysql)))
{
	printf("error\n");
}

and it spits out the error instead, but i'm not sure why the command isn't working... the table exists and has data in it, and the code is connecting to the database ok...

i can't see anything wrong with my syntax....

[jam]

ok now it seems my select command is failing O_O

this is driving me nuts. can anyone shed any light? i'm going in circles

[bithub]

Print out the error code it is returning. Then look at the documentation to see which of the 4 errors you got.

[jam]

i've sorted it now... it worked with `table` not table :P

thanks for the help