query("SELECT * FROM user_table WHERE authorizationrights = 'GRANTED' ")) { while ($row = $result->fetch_assoc() ) { $stdd=$stdd. ""; } } $connect->close(); ?> Ntihc | imm system

'.$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('connect/config.php'); $sql = "SELECT * FROM `items` LEFT JOIN `recievables` ON items.DESCRIPTION=recievables.DESCRIPTION WHERE DISCONTINUE = 'DISABLED' ORDER BY recievables.DESCRIPTION DESC"; $res = $conn->query($sql); while($row=$res->fetch_assoc()){ echo ''. ''. getIndicator($row["CATEGORY"]). getIndicator($row["UNITOFMEASURE"]). getIndicator($row["BATCHNO"]). getIndicator($row["EXPIRYDATE"]). getIndicator($row["EXPIRYREMINDDATE"]). ''; } ?>
DESCRIPTION CATEGORY UNIT OF MEASURE BATCHNO EXPIRYDATE EXPIRYREMINDDATE LOCATION
DESCRIPTION CATEGORY UNIT OF MEASURE BATCHNO EXPIRYDATE EXPIRYREMINDDATE LOCATION
'.$str123.''.$str123.''.$str123.''.$str123.''.$str123.'
'.$row["DESCRIPTION"].''.$row["STORELOCATION"].'