db_get_field_assoc
#9

2 years later.
I am using @Konstantinos method and it's giving me errors

Код:
[00:14:47] [Error] db_query: invalid database handle 0
[00:14:47] [Error] db_num_rows(): invalid result handle 0
[00:14:47] [Error] db_free_result(): invalid result handle 0
Code:
PHP код:
stock LoadWeeds()
{
    new 
DBResult:dbresult;
    
dbresult db_query(Database"SELECT * FROM `plants` ORDER BY `plantid`");

    for (new 
idb_num_rows(dbresult); != ji++)
    {
        
PlantInfo[i][plantID] = db_get_field_assoc_int(dbresult"plantid");
        
PlantInfo[i][plantX] = db_get_field_assoc_float(dbresult"plantX");
        
PlantInfo[i][plantY] = db_get_field_assoc_float(dbresult"plantY");
        
PlantInfo[i][plantZ] = db_get_field_assoc_float(dbresult"plantZ");
        
PlantInfo[i][plantInt] = db_get_field_assoc_int(dbresult"plantInt");
        
PlantInfo[i][plantVW] = db_get_field_assoc_int(dbresult"plantVW");
        
PlantInfo[i][plantValue] = db_get_field_assoc_int(dbresult"plantValue");
        
PlantInfo[i][plantExist] = true;

        
PlantInfo[i][plantObject] = CreateDynamicObject(3409PlantInfo[i][plantX], PlantInfo[i][plantY], PlantInfo[i][plantZ], 0.00.00.0PlantInfo[i][plantVW], PlantInfo[i][plantInt]);
        
db_next_row(dbresult);
    }
    
db_free_result(dbresult);
    return 
1;

Reply


Messages In This Thread
db_get_field_assoc - by JaKe Elite - 11.10.2016, 08:38
Re: db_get_field_assoc - by Konstantinos - 11.10.2016, 08:49
Re: db_get_field_assoc - by JaKe Elite - 11.10.2016, 08:52
Re: db_get_field_assoc - by Konstantinos - 11.10.2016, 09:07
Re: db_get_field_assoc - by JaKe Elite - 11.10.2016, 09:39
Re: db_get_field_assoc - by Konstantinos - 11.10.2016, 09:51
Re: db_get_field_assoc - by JaKe Elite - 11.10.2016, 09:55
Re: db_get_field_assoc - by JaKe Elite - 11.10.2016, 10:07
Re: db_get_field_assoc - by JaKe Elite - 26.01.2018, 22:34
Re: db_get_field_assoc - by JaKe Elite - 27.01.2018, 05:49

Forum Jump:


Users browsing this thread: 1 Guest(s)