MySQL issue.
#1

Hii'.
Firstly, I asking you if it's a good way to do that :
PHP код:
    ...
    
mysql_pquery(MySQL"SELECT * FROM Tag""OnTagCount""");    // count number of tag saved
    
return 1;
}
PUBLIC:
OnTagCount()
{
    new 
rows;
    
cache_get_row_count(rows);
    for(new 
i=1<= rowsi++)
    {
        
mysql_pquery(MySQL"SELECT * FROM Tag WHERE `SQLIB` = '%i'""OnTagLoading""i"i); // load each of them
    
}
    
printf("- Chargement terminй. %i tag chargй."TagNumber);
}
PUBLIC:
OnTagLoading(tagid)
{
    
cache_get_value_name_int(0"ID"p_Tag[tagid][tID]);
    
cache_get_value_name_int(0"SQLIB"p_Tag[tagid][tSQLIB]);
    
cache_get_value(0"Owner"p_Tag[tagid][tOwner]);
... 
If not, please tell me how I should do that.
Secondly, I've these errors:
Код:
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
Reply


Messages In This Thread
MySQL issue. - by Dayrion - 11.12.2016, 14:49
Re: MySQL issue. - by Vince - 11.12.2016, 14:56
Re: MySQL issue. - by X337 - 11.12.2016, 14:58
Re: MySQL issue. - by Dayrion - 11.12.2016, 19:07

Forum Jump:


Users browsing this thread: 3 Guest(s)