Counting Items for iteminfo.php

[Smokey]

I'm hoping someone can help me with this, I am trying to add a count of items in circulation to the iteminfo page.

This is what I have but it only shows 1 item in circulation.

 

$itemcount=$db->num_rows($q);
$q=$db->fetch_single($db->query("SELECT COUNT(*) FROM inventory WHERE inv_itemid = $itmid"));

 

also tried:

 

$itemcount=$db->num_rows($q);
$q=$db->fetch_single($db->query("SELECT COUNT(*) FROM inventory WHERE inv_itemid = $itemcount"));

 

and:

 

$itemcount=$db->num_rows($q);
$q=$db->query("SELECT inv_qty FROM inventory WHERE inv_itemid = $itmid");

[Smokey]

Nevermind, I figured it out.