function getItemsByType($type) { global $db; $sql = "select * from items where itemtype = " . $type; $results = $db->query($sql); $items = array(); while ($row = mysql_fetch_assoc($results)) { $item = new Item(); $item->itemFromArray($row); $items[] = $item; } return $items; }