$rand_banner_query = "update affiliate_products join affiliates on affiliate_products.affiliateid=affiliates.affiliateid set affiliate_products.current_priority=affiliates.priority where affiliate_products.productid='$productid'";
$rand_banner_result = query($rand_banner_query);