format("Y-m-d"); if(isset($_POST['trans'])){ $trans = mysql_escape_string($_POST['trans']); $forPaymentPO = 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 $forPaymentPO; } ?>