query(" SELECT * FROM DimDeliveryDog ddd join DimAnimalType dat on ddd.AnimalTypeID = dat.AnimalTypeID WHERE ddd.DeliveryDogID =" . $ddid); $ddcollars = $dd->query(" SELECT dd.DeliveryDogID , count(*) as CollarDeliveries FROM DimDeliveryDog dd join FactDDTrans ft on ft.DeliveryDogID = dd.DeliveryDogID join DimDDTransType tt on ft.DDTransTypeID = tt.DDTransTypeID where tt.TransType = 'Collar Purchase' and dd.DeliveryDogID =" . $ddid . " group by dd.DeliveryDogID"); $ddemails = $dd->query(" SELECT dd.DeliveryDogID , count(*) as Emails FROM DimDeliveryDog dd join FactDDTrans ft on ft.DeliveryDogID = dd.DeliveryDogID join DimDDTransType tt on ft.DDTransTypeID = tt.DDTransTypeID where tt.TransType = 'Order Receipt' and dd.DeliveryDogID =" . $ddid . " group by dd.DeliveryDogID"); ?>
num_rows > 0) { $row = $dddata->fetch_assoc(); ?>



years old
num_rows > 0) { $cp = $ddcollars->fetch_assoc(); ?> She has delivered collars!
num_rows > 0) { $em = $ddemails->fetch_assoc(); ?> She has delivered emails!
<? echo $row[" title="" />




Shopping Cart