Delivery cost depending on categories

<?php $session =& JFactory::getSession(); $session_id=$session->getID(); ?>

<?php

	
    $link = mysql_connect("localhost", "user", "pass")
        or die("Could not connect : " . mysql_error());
	mysql_query ("SET CHARACTER SET 'utf8'", $link);
	mysql_select_db("db_name") or die("Could not select database");


    $query = 'SELECT DISTINCT hje52_hikashop_category.category_name, hje52_hikashop_category.min_sum, hje52_hikashop_category.price_delivery FROM hje52_hikashop_product, ((hje52_hikashop_cart INNER JOIN hje52_hikashop_cart_product ON hje52_hikashop_cart.cart_id = hje52_hikashop_cart_product.cart_id) INNER JOIN hje52_hikashop_product_category ON hje52_hikashop_cart_product.product_id = hje52_hikashop_product_category.product_id) INNER JOIN hje52_hikashop_category ON hje52_hikashop_product_category.category_id = hje52_hikashop_category.category_id WHERE (((hje52_hikashop_cart.session_id)="'.$session_id.'"));';
	
	$query2 = 'SELECT Sum(hje52_hikashop_cart_product.cart_product_quantity*hje52_hikashop_price.price_value) AS PRZ, hje52_hikashop_category.min_sum
FROM hje52_hikashop_cart INNER JOIN (((hje52_hikashop_cart_product INNER JOIN hje52_hikashop_price ON hje52_hikashop_cart_product.product_id = hje52_hikashop_price.price_product_id) INNER JOIN hje52_hikashop_product_category ON hje52_hikashop_cart_product.product_id = hje52_hikashop_product_category.product_id) INNER JOIN hje52_hikashop_category ON hje52_hikashop_product_category.category_id = hje52_hikashop_category.category_id) ON hje52_hikashop_cart.cart_id = hje52_hikashop_cart_product.cart_id
WHERE (((hje52_hikashop_cart.session_id)="'.$session_id.'"))
GROUP BY hje52_hikashop_category.category_id, hje52_hikashop_category.min_sum;
';
	
    $result = mysql_query($query) or die("Query failed : " . mysql_error());
	$result2 = mysql_query($query2) or die("Query failed : " . mysql_error()); ?>
	

<?php				while ($row = mysql_fetch_array($result2, MYSQL_ASSOC))
{
	if ($row['min_sum'] > $row['PRZ']) 
	{
		echo "<div class=\"error_sum\">The total of your order is too low for all the possible shipping methods.</div>";
	}
} ?>

<?php	

	$col2_sum = 0;
    print "<table class=\"chekout_price_table_th\">\n";
	print "<tr><th></th><th>Minimum amount</th><th>Delivery cost</th></tr>\n";
    while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
	$col2_sum += $line['price_delivery'];
        print "\t<tr>\n";
        foreach ($line as $col_value) {
            print "\t\t<td class=\"chekout_price_table\">$col_value</td>\n";
        }
        print "\t</tr>\n";
    }
    print "</table>\n";

    mysql_free_result($result);
	mysql_free_result($result2);
    mysql_close($link);
?>

<td class="hikashop_cart_total_value">
						<span class="hikashop_checkout_cart_final_total">
						<?php
							echo $this->currencyHelper->format($this->full_total->prices[0]->price_value_with_tax+$col2_sum,$this->full_total->prices[0]->price_currency_id);
						?>
						</span>
					</td>

foreach($dbrates as $k => $rate){
	if($rate->shipping_type=='manual' && !empty($rate->shipping_published)){
		$rates[]=$rate;

$rates[0]->shipping_price=$col2_sum;

foreach($dbrates as $k => $rate){
			if($rate->shipping_type=='manual' && !empty($rate->shipping_published)){
				$rates[]=$rate;
				$rates[0]->shipping_price=$col2_sum;
			}
		}

function onShippingDisplay(&$order, &$dbrates, &$usable_rates, &$messages) {

	/* START Harry Delivery*/
	$session =& JFactory::getSession(); $session_id=$session->getID();
    $link = mysql_connect("localhost", "*user*", "*pass*") or die("Could not connect : " . mysql_error());
	mysql_query ("SET CHARACTER SET 'utf8'", $link);
	mysql_select_db("*BD*") or die("Could not select database");
    $query = 'SELECT DISTINCT jqp92_hikashop_category.category_name, jqp92_hikashop_category.min_sum, jqp92_hikashop_category.price_delivery FROM jqp92_hikashop_product, ((jqp92_hikashop_cart INNER JOIN jqp92_hikashop_cart_product ON jqp92_hikashop_cart.cart_id = jqp92_hikashop_cart_product.cart_id) INNER JOIN jqp92_hikashop_product_category ON jqp92_hikashop_cart_product.product_id = jqp92_hikashop_product_category.product_id) INNER JOIN jqp92_hikashop_category ON jqp92_hikashop_product_category.category_id = jqp92_hikashop_category.category_id WHERE (((jqp92_hikashop_cart.session_id)="'.$session_id.'"));';
    $result = mysql_query($query) or die("Query failed : " . mysql_error());
	$col2_sum = 0;
    while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {$col2_sum += $line['price_delivery'];}
    mysql_free_result($result);
    mysql_close($link);	
	/* END Harry Delivery*/
	
		$config =& hikashop_config();

foreach($dbrates as $k => $rate) {
			if($rate->shipping_type == $this->name && !empty($rate->shipping_published)) {
				$rates[] = $rate;
				$rates[0]->shipping_price=$col2_sum;
			}
		}

$rate->shipping_price=$col2_sum;

$rate->shipping_price+=$col2_sum;

stdClass Object ( [shipping_id] => 1 [shipping_type] => manual [shipping_zone_namekey] => [shipping_tax_id] => 0 [shipping_price] => 0.00000 [shipping_currency_id] => 81 [shipping_name] => Курьерская доставка [shipping_description] => [shipping_published] => 1 [shipping_ordering] => 3 [shipping_params] => stdClass Object ( [shipping_percentage] => 0 [shipping_per_product] => 0 [shipping_price_per_product] => [shipping_min_price] => [shipping_max_price] => [shipping_price_use_tax] => 1 [shipping_virtual_included] => 1 [shipping_override_address] => 0 [shipping_override_address_text] => [shipping_min_weight] => [shipping_max_weight] => [shipping_weight_unit] => kg [shipping_zip_prefix] => [shipping_min_zip] => [shipping_max_zip] => [shipping_zip_suffix] => [shipping_min_volume] => [shipping_max_volume] => [shipping_size_unit] => m ) [shipping_images] => [shipping_access] => all [shippingkey] => 0,1 [shipping_warehouse_id] => 0 [shipping_price_with_tax] => 0.00000 [shipping_price_orig_with_tax] => )