[JaKe Elite]

Is it possible to store MySQL's NOW() Date & Time function to a variable?

PHP код:

mysql_format(mysql, query, sizeof(query), "INSERT INTO `accounts` (`NAME`, `REGISTRATION`, `IP`, `PASSWORD`, `SALT`) VALUES ('%e', NOW(), '%s', '%s', '%e')", PlayerInfo[playerid][p_Name], PlayerInfo[playerid][p_newIP], PlayerInfo[playerid][p_Password], PlayerInfo[playerid][p_Salt]);
mysql_tquery(mysql, query, "OnPlayerRegister", "d", playerid); 


[AjaxM]

Insert it and fetch the result from the DB through cache.

[JaKe Elite]

Not quite sure if I did it right, I am quite new in terms of mySQL so please excuse me.

Did I do it right?

PHP код:

mysql_format(mysql, query, sizeof(query), "SELECT `REGISTRATION` FROM `accounts` WHERE `NAME` = '%e' LIMIT 1", PlayerInfo[playerid][p_Name]);
mysql_tquery(mysql, query, "RegistrationCache", "d", playerid); 


I have placed it under INSERT INTO and it seems to be working fine, but performance-wise (for the server), is it good?

[JaKe Elite]

Just asking but errr... I guess it is okay then?