DebugString sais 'Error!'

[FSXTim]

Hello,

I have a small problem.

The DebugString sais 'Error!' (line 4), but why?

function MySQL_GetString(tableN, feldN, bedingung) 
    local result = mysql_query(sqlcon, "SELECT "..tableN.." from "..feldN.." WHERE "..bedingung) 
    if (not result) then 
         outputDebugString("Error!") 
    else 
        if(mysql_num_rows(result) > 0) then 
            local ds = mysql_fetch_assoc(result) 
            local savename = feldname 
            mysql_free_result(result) 
            return ds[feldname] 
        else 
            mysql_free_result(result) 
            return false 
        end 
    end 
end 

Greets

[qaisjp]

There is something wrong with your query.

Edited June 10, 2020 by qaisjp
Remove "cos ur gay" at start of post

[FSXTim]

Thanks for your answer.

Here i definied sqlcon:

host = "XX" 
user = "XX" 
pass = "XX" 
db = "XX" 
port = 3306 
  
sqlcon = mysql_connect(host, user, pass, db, port) 

Just for example, here is a script, which is working perfectly with the mysql_query and sqlcon:

function playerLogin ( username,password,email ) 
    local result = mysql_query(sqlcon,"SELECT * FROM user_data WHERE Username='"..mysql_escape_string( sqlcon, username ).."';") 
    if result then 
        rows = mysql_num_rows(result) 
        if rows == 1 then 
            row = mysql_fetch_row(result) 
        end 
        mysql_free_result(result) 
    end 
end 

Greets

[qaisjp]

I don't know mysql, use the DB functions if ur not a pro.

[FSXTim]

Ok, thanks!

Greets