PHP/SQL Help!

[Thisnamewilldo]

Hello, thank you for taking the time to read this.

 

Basically, I have a table in a mySQL database that holds people's inventory on a game and it is stored like this :

 

[2(17:0)x1]

[slotID(ItemID:ItemValue)xAmount]

 

 

I also have another table which stores the hundreds of available items.

 

I need it so that I can do something like:

 

<?
$checktheiritem = mysql_query("SELECT * FROM inventory WHERE owner='$logged[username]'");
while ($theiritem = mysql_fetch_array($checktheiritem)) {
$amount = AMOUNT;
// AMOUNT would need to be the amount from the inventory table.
$getitem = mysql_query("SELECT * FROM items WHERE itemid = 'ITEMID'");
// ITEMID would need to be the item id from the inventory table.
$item = mysql_fetch_array($getitem);
echo "$item[name] x $amount";
}
?>

 

Does anyone have any idea how I can separate the amount, itemid, item value etc from the one result [slotID(ItemID:ItemValue)xAmount]?

 

I tried doing this, my code is below.. but as you can imagine, it is having to check the hundreds of items first which takes about 10 seconds for the script to load. Also I still cannot get the amount.

 

<?
$getitem = mysql_query("SELECT * FROM items");
while ($item = mysql_fetch_array($getitem)) {
$checktheiritem = mysql_query("SELECT * FROM inventory WHERE owner='$logged[username]' AND inventory LIKE '%($item[itemid]:$item[value])%'");
$theiritem = mysql_fetch_array($checktheiritem);
if ($theiritem != NULL) {
echo "$item[name]";
}
}
?>

 

Any help at all would be appreciated!

 

Thanks,

Vince.

[Thisnamewilldo]

Anyone able to solve this or give some sort of advice? It's urgent.

[Pikachu2000]