Query not being called
#1

For my SQL Login system, It seems that my query is not being called.

Код:
new szQuery[256];
format(szQuery,sizeof(szQuery),"INSERT INTO `players` (kills,death,pass) VALUES(0,0,'%s')",pName(playerid), Password);
mysql_query(szQuery, mRegisterAccount, playerid);
Reply
#2

What MySQL plugin are you using?
Reply
#3

Do the tables 'kills, death, and pass' exist in the MySQL database?

You can also try this (probably won't work, but try it anyway):

pawn Код:
new szQuery[256];
format(szQuery,sizeof(szQuery),"INSERT INTO `players` (name, kills, death, pass) VALUES('%s', '0', '0', '%s')",pName(playerid), Password);
mysql_query(szQuery, mRegisterAccount, playerid);
You only specified one string placeholder for the password, when you needed 2.
Be sure to create the 'name' table in your database!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)