[Memoryz]

What's wrong with this query?

Код:

INSERT INTO 'acodes' ('thecode') VALUES ('a51G81baJ11a')

Basically all I want to do is insert the "a51G81baJ11a" into "thecode" field, on the acodes database, and I get this error:

Quote:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''acodes' ('thecode') VALUES ('a51G81baJ11a')' at line 1

Can anyone help me out?


---------------------------- PROBLEM WAS FIXED! --------------

[JaTochNietDan]

Your syntax is a little strange, you don't need those quotes around the column name and you should use the other quotes around the table name, for example:

pawn Код:

"INSERT INTO `acodes` (thecode) VALUES ('a51G81baJ11a')"

[Memoryz]

Quote:

Originally Posted by JaTochNietDan Your syntax is a little strange, you don't need those quotes around the column name and you should use the other quotes around the table name, for example: pawn Код: "INSERT INTO `acodes` (thecode) VALUES ('a51G81baJ11a')"

Okay that runs perfectly, however when I generate a random string and try to insert it via pawno like this:

pawn Код:

new query[195];
format(query, sizeof(query), "INSERT INTO 'acodes' (thecode) VALUES ('%s')", string);
mysql_query(string);

I get an error:

Quote:

Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '9cSV395Y5AEw' at line 1

[[Diablo]]

Quote:

Originally Posted by Memoryz What's wrong with this query? Код: INSERT INTO 'acodes' ('thecode') VALUES ('a51G81baJ11a') Basically all I want to do is insert the "a51G81baJ11a" into "thecode" field, on the acodes database, and I get this error: Can anyone help me out?

you mean you want to insert into table 'acodes' which contain field 'thecode' and you are inserting value 'a51G81baJ11a' ? database is selected at the beginning..

[Memoryz]

Quote:

Originally Posted by [Diablo] you mean you want to insert into table 'acodes' which contain field 'thecode' and you are inserting value 'a51G81baJ11a' ? database is selected at the beginning..

Yea, I am connected to all that, all my other SQL queries run perfectly.

[DRIFT_HUNTER]

pawn Код:

new query[195];
format(query, sizeof(query), "INSERT INTO `acodes` (`thecode`) VALUES ('%s')", string);
mysql_query(string);

[Memoryz]

Quote:

Originally Posted by DRIFT_HUNTER pawn Код: new query[195]; format(query, sizeof(query), "INSERT INTO `acodes` (`thecode`) VALUES ('%s')", string); mysql_query(string);

Quote:

Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '4PYBsw2z0B68' at line 1.

What I am thinking, is that there is a problem with this random string stock?

pawn Код:

stock randomString(strDest[], strLen = 10)
{
    while(strLen--)
        strDest[strLen] = random(2) ? (random(26) + (random(2) ? 'a' : 'A')) : (random(10) + '0');
}

[Jefff]

Quote:

Originally Posted by Memoryz Okay that runs perfectly, however when I generate a random string and try to insert it via pawno like this: pawn Код: new query[195]; format(query, sizeof(query), "INSERT INTO 'acodes' (thecode) VALUES ('%s')", string); mysql_query(string); // maybe query ? xd I get an error:

Try :P

[Memoryz]

Quote:

Originally Posted by Jefff Try :P

I have tried that already.

[Jefff]

Must be

pawn Код:

new query[195];
format(query, sizeof(query), "INSERT INTO `acodes` (`thecode`) VALUES ('%s')", string);
mysql_query(query);

` not ' at acodes and show string