[MySql - Help] How can I stop the A_I from missing numbers?
#8

When i use

Код:
SELECT * FROM table
How do i put each record into an enum? This is what i use atm:

pawn Код:
format(query, sizeof(query), "SELECT * FROM orgvehicles WHERE ID='%d'", i);
    mysql_query(query);
    mysql_store_result();
    while(mysql_retrieve_row()){
        new data[128];
        mysql_fetch_field_row(data, "ID");
        orgVeh[i][vID] = strval(data);

        mysql_fetch_field_row(data, "model");
        orgVeh[i][vModel] = strval(data);

        mysql_fetch_field_row(data, "x");
        orgVeh[i][vX] = strval(data);

        mysql_fetch_field_row(data, "y");
        orgVeh[i][vY] = strval(data);

        mysql_fetch_field_row(data, "z");
        orgVeh[i][vZ] = strval(data);

        mysql_fetch_field_row(data, "angle");
        orgVeh[i][vAngle] = strval(data);
       
        mysql_fetch_field_row(data, "orgID");
        orgVeh[i][vOrgID] = strval(data);


    }
    mysql_free_result();

    orgVeh[i][vTempID] = AddStaticVehicle(orgVeh[i][vModel],orgVeh[i][vX],orgVeh[i][vY],orgVeh[i][vZ],orgVeh[i][vAngle],-1,-1); // Car 1
EDIT:
srry for not getting how to do this..

i culd do it in PHP but not in Pawn... there is no mysql_fetch_array or anything so im not sure what to do
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)