[Cypress]

Hello,

I have a problem selecting ID and name from SQLite databalse.

What I was doing is:

pawn Код:

CMD:savedplayers(playerid, params[])
{
    new string[300], DBResult: result;

    result = db_query(serverDB,  "SELECT `ID` AND  `NAME` FROM `PLAYERS`");

    if (db_num_fields(result))
    {
            format(string, sizeof(string), "%s%s", ...);
            ShowPlayerDialog(playerid, 0, DIALOG_STYLE_LIST, "Saved Player List", string, "Close", "");
        db_free_result(result);
        return 1;
    }
    else
    {
        db_free_result(result);
        return 0;
    }
   return 1;
}

So how do I basically show a list of saved players.. I'm lost.

[Misiur]

Change AND to comma.

[Dubya]

Not sure with SQLite, but I am 50% sure that that query is wrong.

"SELECT `ID` AND `NAME` FROM `PLAYERS`" isn't a complete query.

"SELECT `ID` AND `NAME` FROM `PLAYERS` WHERE 1" is a complete query.

[Cypress]

Quote:

Originally Posted by Misiur Change AND to comma.

You sure that just this will make it work? What about a loop? Is it not needed?

Quote:

Originally Posted by Dubya Not sure with SQLite, but I am 50% sure that that query is wrong. "SELECT `ID` AND `NAME` FROM `PLAYERS`" isn't a complete query. "SELECT `ID` AND `NAME` FROM `PLAYERS` WHERE 1" is a complete query.

What does that WHERE 1 do? As I know WHERE is a clause that is used to extract only those records that fulfill a specified criterion.

[Dubya]

the one stands for a global where ID and Name are both set to something, it will select them.

[Misiur]

SQLite doesn't require WHERE statement (I think, at least looking at http://www.sqlite.org/lang_select.html ). Currently your query selects all names and id's, but the code processes only first row.