[zippoxer]

Hello, I just need an advice about saving a special kind of data in mysql with php :]

I have a table called hunting_areas, it has a field called looted_items.
In looted_items, there should be some items ids and their chance (chance for the user to get them in the specific hunting area). here's an example row (there should be many like this):

Code:

3-80;1-34;5-69;9-13

So in that example row, the user can get item id 3 with a chance of 80%, item id 1 with a chance of 34%, item id 5 with a chance of 69% and item id 9 with a chance of 13%.

There are a lot of other ways to do the above mission for example:
removing the looted_items field and placing: looted_items_ids and looted_items_chances.
an example row (first code is looted_items_ids and second looted_items_chances):

Code:

3;1;5;9

Code:

80;34;69;13

For those who understood, any better ways you know to store this kind of data? In case you didn't understood reply here I'll explain this otherwise.

[wirehopper]

You could use an array or database table, with the ids serving as the indexes and the chances as the values.

Array:

$aLooted[$id]=$chance;

Database:

Table of looted items would have ids, names, and chances.