MySQL Get string/integer - Printable Version

MySQL Get string/integer - 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: MySQL Get string/integer (/showthread.php?tid=613540)

MySQL Get string/integer - Shinja - 28.07.2016

How to get a string/integer from a query to a variable?
i tried something like that

PHP код:



while(mysql_fetch_row(query))

          {

            mysql_fetch_field_row(admin, "Admin");

            mysql_fetch_field_row(IP, "IP");

            mysql_fetch_field_row(reason, "Reason");

            mysql_fetch_field_row(Day, "Day");

            mysql_fetch_field_row(Month, "Month");

            mysql_fetch_field_row(Year, "Year");

            mysql_fetch_field_row(Hour, "Hour");

            mysql_fetch_field_row(Minute, "Minute");

            mysql_fetch_field_row(Second, "Second");

          }

Hmm, maybe it got the first fetch but others are kinda random
I need help, thanks!

Re: MySQL Get string/integer - Flake. - 28.07.2016

PHP код:



var = cache_get_field_content_int(row, "field name", SQL_CONNECTION);

I suggest you give https://sampwiki.blast.hk/wiki/MySQL/R33#cache_get_data a read, it retails how to retrieve other results & how to use the cache.