Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

need to know why its not displaying data

Posted on 2006-10-20
2
154 Views
Last Modified: 2010-04-06
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>
0
Comment
Question by:shihabf
2 Comments
 

Author Comment

by:shihabf
ID: 17774866
please dont worry about it i got it figured out, had a problem with my query itself..
0
 
LVL 28

Accepted Solution

by:
gamebits earned 500 total points
ID: 17777731
Since you fix the problem yourself you can ask a moderator to reimburse your points.

Gamebits
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Article by: Matthew
I am a very big proponent of technology compliance standards and strive to meet such criteria in all of my work. That includes my site, which is 100% XHTML 1.0 compliant as determined by the World Wide Web Consortium. https://www.matthewstevenkel…
Introduction Knockoutjs (Knockout) is a JavaScript framework (Model View ViewModel or MVVM framework).   The main ideology behind Knockout is to control from JavaScript how a page looks whilst creating an engaging user experience in the least …
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
The viewer will learn how to count occurrences of each item in an array.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question