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>
shihabfAsked:
Who is Participating?
 
gamebitsConnect With a Mentor Commented:
Since you fix the problem yourself you can ask a moderator to reimburse your points.

Gamebits
0
 
shihabfAuthor Commented:
please dont worry about it i got it figured out, had a problem with my query itself..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.