'.$str123.''; } else { $str1234=array(); $str1234=explode('_',$tempstr); $cnt = count( $str1234); if($str1234[$cnt-1]==''){ return ''; } else{ return ''; } } return false; } function getIndicator($str123){ $str123 = trim($str123); $tempstr = str_replace('__','_',$str123); if($str123==''){ return ''; } else { $str1234=array(); $str1234=explode('_',$tempstr); $cnt = count( $str1234); if($str1234[$cnt-1]==''){ return ''; } else{ return ''; } } } require('configconns.php'); $sql = "SELECT id,PROPERTYDESCRIPTION,CATEGORY, CODIFICATIONSTATUS,ENGRAVEDNUMBER, VERIFICATIONSTATUS, DATEOFPURCHASE, MAKE,PROPERTYCOST,SUPPLIEDBY, LOCATION,RESPONSIBLEOFFICER,OFFICERCONTACT,FUNCTIONALSTATUS, SERVICEREQUIREMENT,NEXTDUESERVICE,REMINDDATE, PHYSICALSTATUS, CURDATE(), TIMESTAMPDIFF(YEAR,DATEOFPURCHASE,CURDATE()) AS age FROM properties ORDER BY CATEGORY DESC"; $res = $conn->query($sql); while($row=$res->fetch_assoc()){ echo ''. ''. ''. getIndicator($row["PROPERTYDESCRIPTION"]). getIndicator($row["CATEGORY"]). getIndicator($row["LOCATION"]). getIndicator($row["RESPONSIBLEOFFICER"]). getIndicator($row["PROPERTYCOST"]). getIndicator($row["age"]). getIndicator($row["SUPPLIEDBY"]). ''; } ?>

S/NO.	PROPERTY.NO.	DESCRIPTION	CATEGORY	LOCATION	RESPONSIBLE.OFFICER	COST	AGE	SUPPLIER	STATUS
S/NO.	PROPERTY.NO.	DESCRIPTION	CATEGORY	LOCATION	RESPONSIBLE.OFFICER	COST	AGE	SUPPLIER	STATUS
'.$str123.'	'.$str123.'	'.$str123.'	'.$str123.'	'.$str123.'
'.$row["id"].'	'.$row["ENGRAVEDNUMBER"].'	'.$row["PHYSICALSTATUS"].'