[Gammix]

Here is table structure representation:

PHP код:

Items
    ID - INTEGER - PRIMARY_KEY
    Type - INTEGER
    UID - INTEGER - FOREIGN KEY
Users
    ID - INTEGER - PRIMARY_KEY    
    ... 


So to count all items owned by a user:

PHP код:

SELECT `Type` FROM `Items` WHERE `UID` = <user_id> 


Code:

PHP код:

OnLoad()
{
    for (new i, j = cache_get_rows_count(); i < j; i++)
    {
        // do stuff
    }
} 


If you have a max item limit, say #define MAX_ITEMS (10), the for loop will be:

PHP код:

OnLoad()
{
    new limit = cache_get_rows_count();
    if (limit > MAX_ITEMS) 
        limit = MAX_ITEMS;
    for (new i; i < limit ; i++)
    {
        // do stuff
    }
} 


You can use Username instead of UID in case you want string matching. But i recommend UID.