format("Y-m-d"); if(isset($_POST['trans'])){ $trans = mysql_escape_string($_POST['trans']); $ActiveProposal = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_uploadedcanvass` WHERE `deleted`= 0 AND `validity_date` > '$prfDate'"),0); } echo $ActiveProposal; ?>