MySQL issues
#9

Oh, of course, I see what an issue is, you are doing query wrong!

Код:
mysql_format(SQL, string, sizeof(string), "SELECT `code` FROM `users` WHERE `name`='%e' LIMIT 1", playerid);
Here you trying to fetch code based on user's name, but you're sending player's id instead of player's name

That is why you getting nothing back from db
Reply


Messages In This Thread
MySQL issues - by IdonTmiss - 17.07.2018, 10:40
Re: MySQL issues - by denNorske - 17.07.2018, 11:12
Re: MySQL issues - by IdonTmiss - 17.07.2018, 11:19
Re: MySQL issues - by Calisthenics - 17.07.2018, 12:55
Re: MySQL issues - by Ivan_Ino - 17.07.2018, 13:00
Re: MySQL issues - by IdonTmiss - 17.07.2018, 13:19
Re: MySQL issues - by Ivan_Ino - 17.07.2018, 13:22
Re: MySQL issues - by Florin48 - 17.07.2018, 13:24
Re: MySQL issues - by Ivan_Ino - 17.07.2018, 13:26
Re: MySQL issues - by IdonTmiss - 17.07.2018, 13:26

Forum Jump:


Users browsing this thread: 2 Guest(s)