MySQL insert into problem
#1

Okay, I've got this:
pawn Код:
new PIP[56];
GetPlayerIp(id,PIP,56);
new Admin[MAX_PLAYER_NAME];
new User[MAX_PLAYER_NAME];
new hour,minute,second,date,month,year;
gettime(hour,minute,second);
getdate(date,month,year);
format(Query, sizeof(Query), "INSERT INTO `Bans` (`User`, `IP`, `Reason`, `Admin`, `Ban Time`, `Unban Time`) VALUES('%s', '%s', '%s', '%s', '%d/%d/%d', '%d:%d:%d:%d')", User,PIP,reason,Admin,date,month,year,days,hours,minutes,seconds);
mysql_query(Query);
mysql_store_result();
It inserts it, but the correct things are only the ban reason, and the time.
Others are just left blank.
I just can't figure out what I'm doing wrong... help me please, thanks in advance!
Reply


Messages In This Thread
MySQL insert into problem - by [MWR]Blood - 05.02.2011, 10:27

Forum Jump:


Users browsing this thread: 1 Guest(s)