Priting Fields From Mysql - Printable Version

Priting Fields From Mysql - 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: Priting Fields From Mysql (/showthread.php?tid=249695)

Priting Fields From Mysql - ihatetn931 - 20.04.2011

How would i print a single field from a table in to a string you know the

pawn Код:

%s

Example:

I have a table called players and in that table i have a field called PlayerNames

What i wanna do is print all the rows with just the PlayerNames

I have 5 rows each have diffrent names.

I wanna print all the names in to one string.

I'm using striken kids plugin

Re: Priting Fields From Mysql - Retardedwolf - 20.04.2011

pawn Код:

new rQuery[ 50 ];
mysql_query( "SELECT `playerName` FROM `players`" );
mysql_store_result( );
while( mysql_fetch_row_format( rQuery, "|" ) )
{
//Store playername
}

Re: Priting Fields From Mysql - ihatetn931 - 20.04.2011

There isn't a

pawn Код:

mysql_fetch_row_format( rQuery, "|" )

In stricken kids Mysql Plugin.

Re: Priting Fields From Mysql - s0nic - 20.04.2011

Just try this for stricken kids:

pawn Код:

mysql_fetch_row(rQuery);

Because "|" is already set by default in the function
See:
native mysql_fetch_row(dest[], const splitter[] = "|", MySQL:handle = MySQL:0);

Re: Priting Fields From Mysql - ihatetn931 - 20.04.2011

It's only printing the first name in the table. I want it to print all the names

pawn Код:

new rQuery[ 50 ];
            mysql_query( "SELECT PlayersName FROM warrants" );
            mysql_store_result( );
            mysql_fetch_row(rQuery);
            format(str, sizeof (str), "%s\n",Warrants[wPname]);

I'm trying to make it where you can get all warrants in the warrant database, So cops can go through and take care of the warrants in game.

Re: Priting Fields From Mysql - ihatetn931 - 20.04.2011

Lemme Clarify myself

Ok, i have been trying to make a warrant system for cops which is mysql. I got it to insert just fine. But when i go to the dialog to check the warrants, It only prints 1 name or no names.

Baically i want a dialog to show all the names in the database of players who have warrants.

How would i get it to print all the names in the warrants table under field PlayersName.

My enum

pawn Код:

enum wWarrants
{
    wPId,
    wPname[24],
    wWantedFor[64],
    wGivenBy[24],
    wStatus[64]
};
new Warrants[MAX_PLAYERS][wWarrants];

The code that suppose to shwo all the names

pawn Код:

format(Query, sizeof (Query), "SELECT PlayersName FROM warrants");
            mysql_query(Query);
            mysql_store_result( );
            printf("%s",Query);
            format(str, sizeof (str), "%s\n",Warrants[WarrantCount][wPname]);
            switch(listitem)
            {
        case 0: ShowPlayerDialog(playerid, 38, DIALOG_STYLE_LIST, "Open Warrants", str, "Get Info", "Cancel");

I know i got somthing wrong but i can't figure it out.

WarrantCount comes from this

pawn Код:

stock LoadMysqlWarrants()
{
    format(Query, sizeof(Query), "SELECT * FROM warrants");
    mysql_query(Query);
    mysql_store_result();
    if(mysql_num_rows() > 0)
    {
        while(mysql_fetch_row(Query))
        {
            sscanf(Query, "e<p<|>ds[24]s[64]s[24]s[64]>", Warrants [ WarrantCount ]);
            printf("%s",Query);
            printf(" Warrants Id: %s",Warrants[WarrantCount][wPId]);
            printf(" Warrants Name: %s",Warrants[WarrantCount][wPname]);
            printf("Wanted For: %s",Warrants[WarrantCount][wWantedFor]);
            printf("GivenBy: %s",Warrants[WarrantCount][wGivenBy]);
            printf("Status: %s",Warrants[WarrantCount][wStatus]);
            WarrantCount++;
        }
    }
    mysql_free_result();
    printf("%d Warrants('s) Loaded From Mysql DataBase", WarrantCount);
    return 1;
}