MySQL saving
#1

ok im working on some MySql project..

i have managed toconnect the server with my websites MySql
but now this
pawn Код:
mysql_function_query(connectionHandle, "CREATE TABLE IF NOT EXISTS memmbers(Username VARCHAR(24), Money INT(20), Score INT(20), IP VARCHAR(16) , TOS VARCHAR(16) )",false,"OnQueryFinish","","");
new pname[24], IP[16];
GetPlayerName(playerid, pname, 24);
GetPlayerIp(playerid, IP, 16);
//dont worry about the TStr
mysql_function_query(connectionHandle,"INSERT INTO memmbers (Username, Money, Score, IP, TOS) VALUES ('%s','%d','%d','%s','%s')",false,"OnQueryFinish","siiss",pname,GetPlayerMoney(playerid), GetPlayerScore(playerid), IP,TStr);
i debuged the print out from OnQueryFinish it all displays fine but then after i check the MySql database this is what comes up

Код:
Username 	Money 	Score 	IP 	TOS
 	%s 	0 	0 	%s 	0
Reply


Messages In This Thread
MySQL saving - by park4bmx - 25.06.2012, 17:05
Re: MySQL saving - by Jason` - 25.06.2012, 17:18
Re: MySQL saving - by Hawky133 - 25.06.2012, 17:24
Re: MySQL saving - by park4bmx - 25.06.2012, 17:27
Re: MySQL saving - by dowster - 25.06.2012, 18:40
Re: MySQL saving - by park4bmx - 25.06.2012, 20:25

Forum Jump:


Users browsing this thread: 1 Guest(s)