void e_mysql_get_main(void){ MYSQL_ROW row; MYSQL_RES *mysql_result; char *query; char *select_pre = "SELECT stamp, content FROM "; char *select_table = E_MYSQL_TABLE; char *select_suf = " WHERE typ = 'main'"; query = (char *)malloc(strlen(select_pre)+strlen(select_table)+strlen(select_suf)); strcat(query, select_pre); strcat(query, select_table); strcat(query, select_suf); printf("HERI: %s\n", query); mysql_real_query(mysql, query, strlen(query)); e_mysql_check_error("3"); mysql_result = mysql_store_result(mysql); e_mysql_check_error("4"); if((row = mysql_fetch_row(mysql_result) != NULL )){ printf("%s ", row[0]); } mysql_free_result(mysql_result); free(query); }