Saving date in myql
#1

This one doesn't work
Код:
new year, m, d, string[20];
getdate(year, m, d);
format(string, 20, "%02d/%02d/%04d", d, m, year);

mysql_format(mysql, query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Password`, `IP`, `PosX`, `PosY`, `PosZ`, 'RegDate') VALUES ('%e', '%e', '%e', %f, %f, %f, '%e')", playername, pw, ip ,x,y,z, string);
mysql_tquery(mysql, query, "OnAccountRegister", "i", playerid);
This one does work
Код:
mysql_format(mysql, query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Password`, `IP`, `PosX`, `PosY`, `PosZ`) VALUES ('%e', '%e', '%e', %f, %f, %f, )", playername, pw, ip ,x,y,z);
mysql_tquery(mysql, query, "OnAccountRegister", "i", playerid);
Why?
Reply


Messages In This Thread
Saving date in myql - by ax1 - 10.12.2016, 10:37
Re: Saving date in myql - by Vince - 10.12.2016, 10:42
Re: Saving date in myql - by ax1 - 10.12.2016, 10:47
Re: Saving date in myql - by Konstantinos - 10.12.2016, 10:48
Re: Saving date in myql - by ax1 - 10.12.2016, 11:00
Re: Saving date in myql - by Konstantinos - 10.12.2016, 11:04
Re: Saving date in myql - by Runn3R - 10.12.2016, 11:08
Re: Saving date in myql - by ax1 - 10.12.2016, 13:50

Forum Jump:


Users browsing this thread: 1 Guest(s)