Well, what I want is the following:
I have 1 table designated by items, in this table I have 4 columns:
- name
- iditem (Unique ID)
- numerobot
What I want to do is: I want to make a mysql_num_rows of all results, but for each different item name.
In other words, let's suppose that I have 10 results with the name "Shadow Case", 15 results with the name "Gamma Case".
What I want is to do this, so that you know how much of each item I have.
To finish I want to get these values, and make an update to another table that is called infoitens. This table only has 2 columns which are name and quantity, where in quantity I want to put the previous result, for each item.
I hope you have understood me.