[NeXoR]

Hey, when I register someone to the database, while UserID is AUTO_INCREMENT, how can I retrieve his ID to a variable ? PlayerInfo[playerid][UserID] for example ?

PHP код:

            mysql_format(mysql, query, sizeof(query), "INSERT INTO `Users` (`Username`, `IP`, `Registration`, `Password`, `EMail`) VALUES ('%e', '%e', '%e', '%e', '%e')", RPN(playerid), RPIP(playerid),
            date, PlayerInfo[playerid][Password], inputtext);
            mysql_tquery(mysql, query); 


[WhiteKinG]

PHP код:

mysql_format(mysql, query, sizeof(query), "INSERT INTO `Users` (`Username`, `IP`, `Registration`, `Password`, `EMail`) VALUES ('%e', '%e', '%e', '%e', '%e')", RPN(playerid), RPIP(playerid), date, PlayerInfo[playerid][Password], inputtext); 
new Cache:result = mysql_query(mysql, query);
PlayerInfo[playerid][UserID] = cache_insert_id();
cache_delete(result); 


[NeXoR]

Thanks