MYSQL PROBLEM
#4

make sure your MySQL connection collation is utf8_unicode_ci . Some databases won't work on others. Also under OnPlayerConnect:
pawn Код:
format(query, sizeof(query), "SELECT IP FROM `playerdata` WHERE user = '%s' LIMIT 1", pname);
mysql_query(query);
Ip is Column inside table, not SQL Syntax so it has to be inside ``.
pawn Код:
format(query, sizeof(query), "SELECT `IP` FROM `playerdata` WHERE `user` = '%s' LIMIT 1", pname);
mysql_query(query);
Reply


Messages In This Thread
MYSQL PROBLEM - by Danyal - 11.02.2012, 15:58
Re: MYSQL PROBLEM - by Scenario - 11.02.2012, 15:59
Re: MYSQL PROBLEM - by KingHual - 11.02.2012, 16:02
Re: MYSQL PROBLEM - by [MG]Dimi - 11.02.2012, 16:03
Re: MYSQL PROBLEM - by Vince - 11.02.2012, 16:09
Re: MYSQL PROBLEM - by Danyal - 11.02.2012, 17:13
Re: MYSQL PROBLEM - by Scenario - 11.02.2012, 17:43

Forum Jump:


Users browsing this thread: 2 Guest(s)