Anonym

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);
}