Problem with query_sql

Edwardlol · February 21, 2013

I'm having a problem with this:

input .@amigo1$;
            query_sql "SELECT online FROM `char` WHERE name = " +.@amigo1$,.@amigo1[0];

The script load without problems but when I test it and for example write "test" in .@amigo1$ it happen:

I hope you can help :/

Edwardlol · February 21, 2013

That send me a db bug when I write "test" in to the input.

input .@amigo1$;
			query_sql "SELECT online FROM `char` WHERE `name` = "+.@amigo1$,.@amigo1[0];

And I have that.

EDIT: I put

query_sql "SELECT online FROM `char` WHERE `name` = "+"'"+.@amigo1$+"'",.@amigo1[0];

And then it work, very thank you

Edited February 21, 2013 by Edwardlol

goddameit · February 21, 2013

`name` is char style, you need to make searching like this

`name` = '<string>'

Edwardlol · February 21, 2013

I don't understand it :/ Can you make a example with my data?

I put query_sql "SELECT online FROM `char` WHERE `name` = " +.@amigo1$,.@amigo1[0]; and still got the same error.

Edited February 21, 2013 by Edwardlol

goddameit · February 21, 2013

`name` = 'test'

Edwardlol · February 21, 2013

`name` = 'test'

I can't type '.@amigo1$' :/

goddameit · February 21, 2013

are your player named ".@amigo1$"?

you said he is "test" in #1

Edited February 21, 2013 by goddameit

Edwardlol · February 21, 2013

There is a input .@amigo1$;

I want to SELECT that variable in to my query_sql

Edited February 21, 2013 by Edwardlol

goddameit · February 21, 2013

so? problem in where?

I said you need to make searching like this

`name` = '<string>'

if you don't know how to insert variable, read how you did in #1

WHERE name = " +.@amigo1$

Edited February 21, 2013 by goddameit

Question