Mysql count players in clan
#8

Quote:
Originally Posted by Vince
Посмотреть сообщение
This is pretty much the simples of SQL queries that exist. I suggest you read up on SQL some more.

PHP код:
SELECT playername FROM clan_members WHERE clanname 'blah' 
Then use a while-loop to fetch results.
I already have that.
Whats wrong with this:
pawn Код:
case _THREAD_GET_CLAN_MEMBERS :
        {
            new resultline[512];
            mysql_store_result();
            if(mysql_num_rows(gSQL) > 0)
            {
                while(mysql_fetch_row_format(resultline,"|"))
                {
                        mysql_fetch_field_row(resultline,"playername");
                        printf("%s\n",resultline);
                }
            }
            mysql_free_result();
        }
The printf returns blank
Reply


Messages In This Thread
Mysql count players in clan - by Admigo - 20.06.2013, 15:07
Re: Mysql count players in clan - by Niko_boy - 20.06.2013, 15:17
Re: Mysql count players in clan - by Vince - 20.06.2013, 15:21
Re: Mysql count players in clan - by Admigo - 21.06.2013, 14:42
Re: Mysql count players in clan - by Niko_boy - 23.06.2013, 05:27
Re: Mysql count players in clan - by Admigo - 23.06.2013, 07:47
Re: Mysql count players in clan - by Vince - 23.06.2013, 10:18
Re: Mysql count players in clan - by Admigo - 23.06.2013, 11:15
Re: Mysql count players in clan - by Stylock - 23.06.2013, 12:52
Re: Mysql count players in clan - by Admigo - 23.06.2013, 12:57

Forum Jump:


Users browsing this thread: 1 Guest(s)