1)Extract date from timestamp php
date('Y-m-d H:i:s', $timestamp);
2)UNION in php
SELECT SUM(MyCol) FROM
(
SELECT ... MyCol FROM Table1
UNION
SELECT ... MyCol FROM Table2
)
3)Array Merge
$array1 = array();
$array2 = array();
$result = array_merge($array1, $array2);
For more freelance projects and jobs visit www.vkender.com more than 150000 php projects and 5000 php freelancer available here