format("Y-m-d"); if(isset($_POST['trans'])){ $trans = mysql_escape_string($_POST['trans']); $MyCanvassSheet = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `create_canvass_sheet`= 1 AND `deleted`=0 AND `awarded`='0' AND `create_canvass_sheet`= 1 AND `for_execom_canvass_approval`=0 AND `canvass_sheet_creation_ts`=''"),0); echo $MyCanvassSheet; } ?>