Php code to merge two result arrays from databsae.

Php code to merge two result arrays from databsae.

<?php
$con = mysql_connect("localhost", "root", "") or die("Failed to connect to MySql.");
mysql_select_db("db_office", $con) or die("Failed to connect to database");

$start='2012-11-7'; $end='2012-11-8';
$sql1 = "SELECT sum(saleamount) FROM `tb_sales` where `saledate` between '$start' and '$end'";
$sql2 = "SELECT sum(purchaseamount), sum(expenseamount) FROM `tb_tansaction` WHERE trdate between '$start' and '$end'";
$result1=mysql_query($sql1);
$result2=mysql_query($sql2);
$a1=mysql_fetch_array($result1);
$a2=mysql_fetch_array($result2);
$result = array_merge($a1, $a2);
//print_r($result);
echo $result['sum(saleamount)'];
echo $result['sum(purchaseamount)'];
echo $result['sum(expenseamount)'];

?>