[Oficer]

Hi, I have in my database 3 records and I save this into enum > Company[Name]...
And I don't know, how I can show all records, because when I save - cache_get_value_name(0, "Name", Company[Name], 30);
In this enum I have only first record, how I can load all records?

[Florin48]

post the code

[Oficer]

PHP код:

         new query[128];
        mysql_format(DB, query, sizeof(query), "SELECT * FROM `Test`"); 
        mysql_query(DB, query);        
        
        cache_get_value_name(0, "Name", Company[Name], 30);
        cache_get_value_name(0, "Location", Company[Location], 30);
        cache_get_value_int(0, "Cash", Company[Cash]);
                 I using this in dialog, because I wont show all company from database 


It's save only first record from database :/

[Florin48]

PHP код:

new Cache:result = mysql_query(DB, "SELECT * FROM `Test`");         
         for(new i, j = cache_num_rows(); i != j; ++i)
        {
            cache_get_value_name(i, "Name", Company[Name], 30); 
            cache_get_value_name(i, "Location", Company[Location], 30); 
            cache_get_value_int(i, "Cash", Company[Cash]);
        } 


that should help you.

[Oficer]

Thanks Bro!! <333