[rickisme]

This, id != DS[id][DsID]
id = in game id ( can start from 0 )
DS[id][DsID] = sql id ( can start from any number higher than 0 )
Example, in table dealerships, i have 1 row, and value in cloumn DsID is 2
i'm start loading dealerships table by use this code

pawn Код:

mysql_tquery(dbHandle, "SELECT * FROM `dealerships`", "loadDEALERSHIPS");
forward loadDEALERSHIPS();
public loadDEALERSHIPS()
{
    if(cache_num_rows() > 0)
    {
        new i;
        while( i < cache_num_rows())
        {
            DS[i][DsSQLID] = cache_get_field_content_int(i, "DsID", dbHandle);
            printf("DealerShip ID: %d (SQLID: %d) loaded", i, DS[i][DsSQLID]);
            i++
            
        }
    }

}

Server console will print

pawn Код:

DealerShip ID: 0 (SQLID: 2) loaded

So, if i use your code ( /DestroyDealership 0 )

pawn Код:

mysql_format(dbHandle, query, sizeof(query), "DELETE FROM `dealerships` WHERE `DsID` = %d", id);

Query will like this :

pawn Код:

DELETE FROM `dealerships` WHERE `DsID` = 0

And guess what, result is

pawn Код:

[ ! ] Invalid DEALERSHIP ID.

cause there's no row have column DsID value = 0
but if i replace your code with this :

pawn Код:

mysql_format(dbHandle, query, sizeof(query), "DELETE FROM `dealerships` WHERE `DsID` = %d", DS[id][DsID]);

Query will like this :

pawn Код:

DELETE FROM `dealerships` WHERE `DsID` = 2

Result will be :

pawn Код:

[ ! ] Successfully DELETED DealerShip ID: 0. (SQL-ROW-ID: 2)