asked on

need to know why its not displaying data

I am attaching the code, need to know if i am missing anything functiion, array etc..
its very urgent could someone tell me..

i need the code

right now its just displaying cyclecount bancount checkstatus
---------------------------------------------

<?
include_once ("../common/ora.php");
?>
<head>
<link rel="stylesheet" type="text/css" href="../common/newReject.css">
<script src="sorttable.js"></script>
<title> User Table </title>
</head>
<html>
<body>
<?php
$curtime=date(" m/d/Y, H:i:s");
$excluded_users="'EnbPS','super','ztest1','ztest2','system','ff9836','RocTS','apptier2','Admin1'";
//====================================================================
function no_login($excluded_users){

$select_count_tab = "SELECT distinct COUNT(NB.CYCLE_ID) as cyclecount,COUNT(NB.BAN) as bancount,nb.FIX_CHECK_STATUS
FROM NEW_BAN_FIX_CKBRD NB, WRK_REJECT_USERS RU, WRK_CYC_OWNER_ARCHIVE WR,HIST_BAN_FIX_CKBRD HB
WHERE NB.FIX_USER_ID = RU.USER_ID
AND WR.CYCLE_ID = NB.CYCLE_ID
AND NB.CYCLE_ID = HB.CYCLE_ID
AND NB.FIX_CHECK_STATUS = '1'
AND RU.user_id not in ($excluded_users)
AND WR.K_DATE <=(TRUNC(SYSDATE)-1)
GROUP BY RU.USER_NAME,NB.CYCLE_ID,NB.BAN,NB.FIX_CHECK_STATUS";

$new_query_array = exec_stat_query($select_count_tab);
return $new_query_array;
}

// no_login($excluded_users);
$new_query_array=no_login($excluded_users) ;
//==============================================================================
echo "<div align=center>";
echo "<tr class='DataRecord'>";
echo "<table width=80% align=center border=1 id=slasum class='sortable' border-color='#990000'>";
echo "<br>";
echo "<h4 align='center'><font color='#0033FF'> Display status </font></h4>";
echo "<tr class=HeaderRow>";
echo "<td align=left style=background-color:#FFCC99 >CycleCount</td>";
echo "<td align=left style=background-color:#FFCC99 >BanCount</td>";
echo "<td align=left style=background-color:#FFCC99 >CheckStatus</td>";
echo "</div>";

//echo "print b: $new_query_array[$i][0]";
//echo "print 1";

for ($i=0; $i<count($new_query_array); $i++){
echo "<tr class='DataRecord'>";
echo "print 2";
echo "<td align=left >". $new_query_array[$i][0] ."</td>";
echo "<td align=left >". $new_query_array[$i][1] ."</td>";
echo "<td align=left >". $new_query_array[$i][2] ."</td>";

echo "</tr>";
}

//===============================================================================

echo "</table>";
?>
</body>
</html>

shihabf

ASKER

please dont worry about it i got it figured out, had a problem with my query itself..

ASKER CERTIFIED SOLUTION

gamebits

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial