function FindSupplies() { $this->MakeSafe(); /* Return all of the bins where this SupplyID is found */ $sql = "SELECT a.* FROM fac_BinContents a, fac_SupplyBin b WHERE \n\t\t\ta.SupplyID={$this->SupplyID} AND a.BinID=b.BinID ORDER BY b.Location ASC;"; $binList = array(); foreach ($this->query($sql) as $row) { $binList[] = BinContents::RowToObject($row); } return $binList; }