Help with MySQL - Printable Version

Help with 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: Help with MySQL (/showthread.php?tid=397923)

Help with MySQL - Frapsy - 07.12.2012

I do not understand the principle of a little. Suppose this code:

PHP код:



        mysql_store_result();

        if (mysql_num_rows() >= 1)

        {

                new tmp[MAX_STRING];

                mysql_retrieve_row();

               

                mysql_get_field("ID", tmp);

                SetPVarInt(playerid, "MySQL_ID", strval(tmp));

How to determine where to save the query results? Where pull information?

Next, let's say I want to display nicknames players who are in the n-th organization. The query:

PHP код:



SELECT `Name` FROM `users` WHERE `Org` = 'n'

These nicknames are written to a variable, as they then bring in a column?

Re: Help with MySQL - Frapsy - 07.12.2012

up_(5sim)

Re: Help with MySQL - Frapsy - 07.12.2012

Surely no one can help?