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)'];

?>

Date Comparison in java with Calander Class

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;

public class date {

public static void main (String args[]) throws ParseException
{


SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
    Date expiry = sdf.parse("2012-11-09");
    Date today1 = new Date();
    String dt = sdf.format(today1);
    Date today = sdf.parse(dt);
    System.out.println(today);
    System.out.println(sdf.format(expiry));


    Calendar cal1 = Calendar.getInstance();
    Calendar cal2 = Calendar.getInstance();
    cal1.setTime(expiry);
    cal1.add(Calendar.DATE, -2);
    cal2.setTime(today);
    System.out.println(cal1.getTime());
    System.out.println(cal2.getTime());
   

        int j = cal2.compareTo(cal1);

        System.out.println("The result is :" + j);
}

}