[vernz]

So, I have this query

PHP код:

mysql_format(sqlConnection, query, sizeof(query), "SELECT *, DATE_FORMAT(lastlogin, '%%e/%%c/%%Y') AS date_time FROM players WHERE username = '%e' AND password = '%e'", GetPlayerNameEx(playerid), password);
mysql_tquery(sqlConnection, query, "OnQueryFinished", "ii", THREAD_ACCOUNT_LOGIN, playerid 


PHP код:

new date[64];
cache_get_field_content(0, "date_time", date, sqlConnection, 64); 


PHP код:

SendClientMessageEx(playerid, -1, "Your last login was on the %s", date); 


it shows me NULL when the player spawn, I'm not sure what is wrong with it, any ideas ?

[Vince]

Print the query. I suspect the mysql_format function is getting confused with those extra percent signs.

[vernz]

PHP код:

SELECT *, DATE_FORMAT(lastlogin, 'e/ 


also

PHP код:

[15:13:28 05/09/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("date_time") (Query: "SELECT * FROM players WHERE id = 4 LIMIT 1") 


[vernz]

PHP код:

specifiers[] = "%%D of %%M, %%Y @ %%k:%%i"; 


PHP код:

mysql_format(sqlConnection, query, sizeof(query), "SELECT *, DATE_FORMAT(lastlogin, '%e') AS date_login FROM players WHERE username = '%e' AND password = '%e'", specifiers, GetPlayerNameEx(playerid), password); 


print:

PHP код:

SELECT *, DATE_FORMAT(lastlogin, '%D of %M, %Y @ %k:%i') AS date_login FROM players WHERE username = etc... 


No values assign to it ?

[vernz]

bump

[Jefff]

Show more info, database screenshot with lastlogin type and create table