[SOLVED] Count and Match Values in an Array to a Database Table

[Ken2k7]

It doesn't echo out the $sql? Hmm...

 

Try this -

$query = mysql_query("SELECT Inventory FROM Users WHERE Username='$cookie' LIMIT 1");
$getquery = mysql_fetch_assoc($query);
$inventory = substr($getquery['Inventory'], 0, -1);

$inventory = explode(',',$inventory);
$inventory = array_count_values($inventory);

$item_names = array();

$sql = "SELECT ItemID, ItemName FROM Items WHERE ItemID IN (" . $inventory . ") AND ItemType='Box'";
var_dump($sql);
$query = mysql_query($sql);
while ($row = mysql_fetch_assoc($query)) {
     $item_names[$row['ItemID']] = $row['ItemName'];
}
var_dump($item_names);
var_dump($inventory);
foreach ($inventory as $key => $count) {
     echo '<div class="item">' . $item_names[$key] . ' (' . $count . ')</div>';
}

[CloudSex13]

Progress! It didn't die short this time and echoed out the following on the page:

 

string(78) "SELECT ItemID, ItemName FROM Items WHERE ItemID IN (Array) AND ItemType='Box'" array(0) { } array(1) { [""]=>  int(1) }
(1)

[Ken2k7]

Oh my god, I am an idiot!

 

$query = mysql_query("SELECT Inventory FROM Users WHERE Username='$cookie' LIMIT 1");
$getquery = mysql_fetch_assoc($query);
$inventory = substr($getquery['Inventory'], 0, -1);

$item_names = array();
$sql = "SELECT ItemID, ItemName FROM Items WHERE ItemID IN (" . $inventory . ") AND ItemType='Box'";
var_dump($sql);

$inventory = explode(',',$inventory);
$inventory = array_count_values($inventory);

$query = mysql_query($sql);
while ($row = mysql_fetch_assoc($query)) {
     $item_names[$row['ItemID']] = $row['ItemName'];
}
var_dump($item_names);
var_dump($inventory);
foreach ($inventory as $key => $count) {
     echo '<div class="item">' . $item_names[$key] . ' (' . $count . ')</div>';
}

[CloudSex13]

That actually worked!

 

It outputted the following:

 

(2)
Box1 (6)
Box2 (

 

The (2) would be an ItemType that's "Plastic", and not a "Box".

 

So this would mean I'd have to separate everything into different Inventory fields in the database to get everything to display properly in sections, but it does work.

 

I sent you a message about what I meant to talk about.

 

Thanks SO much Ken2k7, for you help!

[Ken2k7]

Sweet. Take out all the var_dump() but I assume you already did that. If this is solved, please mark it as so. Lastly, do I still have to read that paragraph in the PM?

[CloudSex13]

lol, it'd be helpful.