format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $prfDateTime=$prfDate. " ".$prfTime; if(isset($_POST['trans'])){ //$UDvendorsUpdate = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`= 6"),0); $UDvendorsUpdate = mysql_result(mysql_query("SELECT COUNT(1) FROM (SELECT * FROM `prf_delivery_receiving_logs` WHERE `inv_status`='Unpaid' GROUP BY `inv_number`) t1 "),0); echo $UDvendorsUpdate; } ?>