From f75219513987997eb6aec17f8a28eb44c3b92959 Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Sat, 24 Sep 2005 19:20:10 +0000 Subject: [PATCH] r441: Get pcv from datastore; queries -= 2 --- includes/functions.php | 6 ++---- 1 file changed, 2 insertions(+), 4 deletions(-) diff --git a/includes/functions.php b/includes/functions.php index 965be6c..53bedb6 100755 --- a/includes/functions.php +++ b/includes/functions.php @@ -81,8 +81,7 @@ function construct_pcv_select($select = '', $prefix = '--') $selected = ' selected="selected"'; - $products_fetch = $bugsys->db->query("SELECT * FROM " . TABLE_PREFIX . "product ORDER BY displayorder ASC"); - while ($product = $bugsys->db->fetch_array($products_fetch)) + foreach ($bugsys->datastore['product'] AS $product) { if ($product['componentmother']) { @@ -94,8 +93,7 @@ function construct_pcv_select($select = '', $prefix = '--') } } - $versions_fetch = $bugsys->db->query("SELECT * FROM " . TABLE_PREFIX . "version ORDER BY displayorder"); - while ($version = $bugsys->db->fetch_array($versions_fetch)) + foreach ($bugsys->datastore['version'] AS $version) { $versions["$version[productid]"]["$version[versionid]"] = $version; } -- 2.22.5