[JoelR]

Hello. I'm creating something with my MySQL information and I want it to be displayed all in one.


Say, I have:

pawn Код:

new query[128];
format(query, sizeof(query), "SELECT * FROM `admins` WHERE `adminid` = 2");
mysql_query(query);

How could I display every result set that comes from it using MySQL R6?

I was thinking about the PHP mysql_fetch_array, but it's different obviously.

Thanks.

[Peach]

You'd want to check and see if there were any rows available through the query by using: mysql_num_rows and then if the query was a success use mysql_get_field and go from there either placing the data into a dialog or string of text.

[JoelR]

Thank you! I'll give that a shot.

[JoelR]

I'm still having a problem with this. Can't seem to get it working, please could you give me an example displayed on a dialog?

Thanks!

Edit: Was meant to be an edit sorry

[Peach]

Just a quick example I wrote for you, this is completely untested but should give you a rough idea of what you're expecting.

pawn Код:

public LoadAdmins()
{
    new admins[250], query[100];
    format(query, sizeof(query), "SELECT * FROM `admins` WHERE `adminid` = '2' LIMIT 25"); // LIMIT OF 25.
    mysql_query(query);
    mysql_store_result();
    new numberofadmins = mysql_num_rows();
    for(new admins = 0; admins < numberofadmins; admins++)
    {
        while(mysql_retrieve_row())
        {
            mysql_fetch_field_row(admins, "Name"); /* Variables here */ = strval(admins);
            mysql_fetch_field_row(admins, "Adminlevel"); /* Variables here */ = strval(admins);
            admins ++;
        }
    }
    mysql_free_result();
    return true;
}

[JoelR]

pawn Код:

new admins[250], query[100], name[24], rank, online, string[256];  
format(query, sizeof(query), "SELECT * FROM admins WHERE alevel= 2");
mysql_query(query);
mysql_store_result();
new numberofadmins = mysql_num_rows();
for(new admins1 = 0; admins1 < numberofadmins; admins1++)
{
    while(mysql_retrieve_row())
    {
        mysql_fetch_field_row(admins, "uname"); format(name, sizeof(name), "%s", admins);
        mysql_fetch_field_row(admins, "alevel"); rank = strval(admins);
        mysql_fetch_field_row(admins, "onlinestatus"); online = strval(admins);
        admins1 ++;
    }
}
mysql_free_result();

format(string, sizeof(string), "%s\n%s (Level: %d Online: %d)", string, name, rank, online);
ShowPlayerDialog(playerid, 9999, DIALOG_STYLE_LIST, "Admins", string, "OK", "");

That's not working.

It displays the first person in it at that's it.

[Unte99]

It would be best for you to analyze the for loop. Search in the wiki or somewhere else for some examples. When you get to work the loop correctly, you will need strins(ert) function to add to the dialog string the admins strings.

[JoelR]

I have no clue of this please could you help me?

[JoelR]

Anyone? It's important.

[[HiC]TheKiller]

pawn Код:

new adminstring[1024]/*Make the string as small as possible ;)*/, name[24], rank, online, string[10];  
mysql_query("SELECT * FROM admins WHERE alevel= 2");
mysql_store_result();
new numberofadmins = mysql_num_rows();
format(adminstring, sizeof(adminstring) "{FF0000}Current admins: %d{FFFFFF}\n", numberofadmins);
while(mysql_retrieve_row())
{
    mysql_fetch_field_row(name, "uname");
    mysql_fetch_field_row(string, "alevel"); rank = strval(string);
    mysql_fetch_field_row(string, "onlinestatus"); online = strval(string);
    format(adminstring, sizeof(adminstring), "%s\n%s (Level: %d Online: %d)", adminstring, name, rank, online);
}
mysql_free_result();
ShowPlayerDialog(playerid, 9999, DIALOG_STYLE_LIST, "Admins", adminstring, "OK", "");

Give that a go.