[Shinja]

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!

[Flake.]

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.