MySQL query
#1

pawn Код:
strcat(query, "INSERT INTO `playerdata` (`username`, `password`, `CHAR_CREATED1`, `CHAR_NAME1`, `CHAR_SKINID1`, `CHAR_KI1`, `CHAR_TOTKI1`, ");
    strcat(query, "`CHAR_CREATED2`, `CHAR_NAME2`, `CHAR_SKINID2`, `CHAR_KI2`, `CHAR_TOTKI2`, ");
    strcat(query, "`CHAR_CREATED3`, `CHAR_NAME3`, `CHAR_SKINID3`, `CHAR_KI3`, `CHAR_TOTKI3`, ");
    strcat(query, "`CHAR_CREATED4`, `CHAR_NAME4`, `CHAR_SKINID4`, `CHAR_KI4`, `CHAR_TOTKI4`) ");
    strcat(query, "VALUES ('%s', '%s', '0', 'None', '0', '0', '0', '0', 'None', '0', '0', '0', '0', 'None', '0', '0', '0', '0', 'None', '0', '0', '0')\", PlayerName(playerid), HashStr);");
I had to use strcat, but last values (PlayerName(playerid) and HashStr) are treaded as text. I know I have to change something with quote marks, but I have no idea how do I change it, because I am new to MySQL honestly.

Appreciate any help.
Reply


Messages In This Thread
MySQL query - by Riddick94 - 26.11.2013, 10:31
Re: MySQL query - by 0x41726d79 - 26.11.2013, 10:38
Re: MySQL query - by Vince - 26.11.2013, 10:44
Re: MySQL query - by Riddick94 - 26.11.2013, 10:45
Re: MySQL query - by Vince - 26.11.2013, 10:58

Forum Jump:


Users browsing this thread: 2 Guest(s)