Cacher is the code snippet organizer for pro developers

$sql_service_info = mysql_query("SELECT proSalePrice, (SELECT taxPercentage FROM tblTaxes WHERE taxID = proTaxID) as proTaxID, proPromoDiscount, proPromoExpirationDate, proPoints FROM tblProducts WHERE proID = '$ryyservice'");
        $num_service_info = mysql_num_rows($sql_service_info); 
        for($i = 1; $i <= $num_service_info; $i++)
        {
           $row_service_info = mysql_fetch_assoc($sql_service_info);
           $ServicePrice =  $row_service_info['proSalePrice'];
           $ServiceTaxID =  $row_service_info['proTaxID'];
           $ServiceTax = $ServicePrice * $ServiceTaxID; 
           $ServicePromoDiscount =  $row_service_info['proPromoDiscount'];
           $ServicePromoExpirationDate =  $row_service_info['proPromoExpirationDate'];
           $ServicePoints = $row_service_info['proPoints'];
           }

$sql = "SELECT casOpeCreationDate FROM tblCashOperations WHERE casOpeDraID = '$ryycasOpeDraID' AND casOpeType = '1' ORDER BY casOpeCreationDate DESC LIMIT 1";
$cashOpeDateStart = $dgrid->SelectSqlItem($sql);