Penny Dreadful Update

query($sGetProds)){ die('There was an error running the query [' . $dblink->error . ']');} while($rowGetProds = $resGetProds->fetch_assoc()) { $sGetProductItem = "SELECT * FROM `".DB_TABLE."product` WHERE `active`=1 AND `productID`=".$rowGetProds['productID'].""; if(!$resGetProductItem = $dblink->query($sGetProductItem)){ die('There was an error running the query [' . $dblink->error . ']');} $rowGetProductItem = $resGetProductItem->fetch_assoc(); $sGetProdBrand = "SELECT * FROM `".DB_TABLE."brandTag` WHERE `brandID`=".$rowGetProductItem['prodCollectionID'].""; if(!$resGetProdBrand = $dblink->query($sGetProdBrand)){ die('There was an error running the query [' . $dblink->error . ']');} $rowGetProdBrand = $resGetProdBrand->fetch_assoc(); $sGetProdFeatImg = "SELECT * FROM `".DB_TABLE."product_image` WHERE `productID`=".$rowGetProductItem['productID']." AND `imgType`='thumbnail' AND `current`=1 AND `active`=1"; if(!$resGetProdFeatImg = $dblink->query($sGetProdFeatImg)){ die('There was an error running the query [' . $dblink->error . ']');} $rowGetProdFeatImg = $resGetProdFeatImg->fetch_assoc(); $sGetProdType = "SELECT * FROM `".DB_TABLE."product_type` WHERE `productTypeID`=".$rowGetProductItem['prodTypeID'].""; if(!$resGetProdType = $dblink->query($sGetProdType)){ die('There was an error running the query [' . $dblink->error . ']');} $rowGetProdType = $resGetProdType->fetch_assoc();?>