How can I retrive user ID ? (MySQL)

How can I retrive user ID ? (MySQL) - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: How can I retrive user ID ? (MySQL) (/showthread.php?tid=618891)

How can I retrive user ID ? (MySQL) - NeXoR - 10.10.2016

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);

Re: How can I retrive user ID ? (MySQL) - WhiteKinG - 10.10.2016

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);

Re: How can I retrive user ID ? (MySQL) - NeXoR - 10.10.2016

Thanks