public static function getSKUsForProduct($id) { $sql = "SELECT s.child_id FROM `catalog_product_relation` as s\nWHERE s.parent_id = {$id}"; $con = mysql_connect(StoreConfigManager::getDbHost(), StoreConfigManager::getDbUser(), StoreConfigManager::getDbPass()) or die("Could not connect: " . mysql_error()); mysql_select_db(strtolower(StoreConfigManager::getDbName())); $result = mysql_query($sql); $skuList = array(); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $skuList[] = $row['child_id']; } mysql_free_result($result); return $skuList; }