mysql select
#1

Hello, i have a mysql select but its wrong, and i donw know why..

Код:
format(query, sizeof(query), "SELECT `ID` FROM `friends` WHERE `friend1` = '%d' AND `friend2` = '%d' OR `friend1` = '%d' AND `friend2` = '%d'", PlayerData[playerid][pID], PlayerData[i][pID], PlayerData[i][pID], PlayerData[playerid][pID]);
And in the log, friend1's id is okay, but the friend2's id is always '' (none).
I debug it with printf(playerdata[playerid[pid]....[i][pid]) and its good. but in the mysql nothing. :/
any idea? thanks!
Reply


Messages In This Thread
mysql select - by n00el - 09.01.2015, 05:50
Re: mysql select - by ball - 09.01.2015, 12:46

Forum Jump:


Users browsing this thread: 2 Guest(s)