Mysql SELECT - Printable Version

Mysql SELECT - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Mysql SELECT (/showthread.php?tid=183909)

Mysql SELECT - gedux123775 - 17.10.2010

Hi, my problem is mysql

PHP код:



MySQLCheck();

new resultline[1024],fetch[258];

format(query,1024,"SELECT * FROM `players` WHERE Job = '1' LIMIT 10");

mysql_query(query);

mysql_store_result();

//new vardas;

mysql_fetch_row(resultline);

mysql_fetch_field_row(fetch,"PName");

sscanf(fetch, "s[128]", gangDB[gangid][leader]);

printf("%s",gangDB[gangid][leader]);

mysql_free_result();

And server_log.txt

PHP код:



[12:52:10] Name_Nickname

[12:52:10] Name_Nickname

[12:52:10] Name_Nickname

[12:52:11] Name_Nickname

[12:52:11] Name_Nickname

[12:52:11] Name_Nickname

[12:52:11] Name_Nickname

[12:52:11] Name_Nickname

[12:52:11] Name_Nickname

[12:52:11] Name_Nickname

[12:52:11] Name_Nickname

[12:52:11] Name_Nickname

[12:52:11] Name_Nickname

[12:52:11] Name_Nickname

[12:52:11] Name_Nickname

[12:52:11] Name_Nickname

[12:52:11] Name_Nickname

[12:52:11] Name_Nickname

[12:52:11] Name_Nickname

[12:52:12] Name_Nickname

[12:52:12] Name_Nickname

[12:52:12] Name_Nickname

[12:52:12] Name_Nickname

[12:52:12] Name_Nickname

[12:52:12] Name_Nickname

[12:52:12] Name_Nickname

[12:52:12] Name_Nickname

[12:52:12] Name_Nickname

[12:52:12] Name_Nickname

[12:52:12] Name_Nickname

Re: Mysql SELECT - iJumbo - 17.10.2010

where u add the script in what public or callback?

Re: Mysql SELECT - gedux123775 - 17.10.2010

OnGameModeInit()

Re: Mysql SELECT - Jay_ - 17.10.2010

You need to show us your full code. What does that mean in the server_log? Are you printing that somewhere else? If so where?