[BlackRaven]

I got this code and it isnt loading all the values from the mysql database. What is wrong?

pawn Код:

forward LoadVehicles();
public LoadVehicles()
{
    new Query[500];
    for(new i; i < MAX_VEHICLES; i++) // Makes an loop so all vehicles get loaded.
    {
        format(Query, sizeof(Query), "SELECT * FROM vehicles WHERE id= %d", i);
        mysql_query(Query); // Querys the "Query" Variable.
        mysql_store_result(); // Stores the result from Query
        if(mysql_num_rows()) // Checks if theres anyrow.
        if(mysql_fetch_row(Query)) // Splits the row
        {
            sscanf(Query, "p<|>e<iiiiffffs[24]s[24]iiiiiii>", vehicleinfo[i]);
            printf("type = %d", vehicleinfo[i][type]);
            if(vehicleinfo[i][type] != 1)
            {
                new globalkey;
                globalkey = CreateVehicle(vehicleinfo[i][Model],vehicleinfo[i][x],vehicleinfo[i][y],vehicleinfo[i][z],vehicleinfo[i][a],vehicleinfo[i][Color1],vehicleinfo[i][Color2], 60*10000);
                printf("query: %s", Query);
                key[globalkey] = vehicleinfo[i][id];
                new engine,lights,alarm,doors,bonnet,boot,objective;
                GetVehicleParamsEx(globalkey,engine,lights,alarm,doors,bonnet,boot,objective);
                SetVehicleParamsEx(globalkey,0,lights,alarm,doors,bonnet,boot,objective);
                vehicleinfo[i][Engine] = 0;
                
            }
        }
    }
}
enum vInfo()
{
    id,
    Model,
    Color1,
    Color2,
    Float:x,
    Float:y,
    Float:z,
    Float:a,
    Name[MAX_PLAYER_NAME],
    Owner[MAX_PLAYER_NAME],
    Lock,
    Parked,
    Spawned,
    Destroyed,
    Licenses,
    Engine,
    type,
}
new vehicleinfo[MAX_VEHICLES][vInfo];

[BlackRaven]

+rep for who helps me.

[SuperViper]

pawn Код:

if(!mysql_num_rows()) continue; // Checks if theres anyrow.

[BlackRaven]

Yes there are 4 rows.