Solved

need to know why its not displaying data

Posted on 2006-10-20
2
153 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

When you work with shopping cart / ecommerce relates web sites, you need to pass the certain form post details to the payment gateway process page with required details for the products items you give to order. Also you may need to track the ordered…
Preface This is the third article about the EE Collaborative Login Project. A Better Website Login System (http://www.experts-exchange.com/A_2902.html) introduces the Login System and shows how to implement a login page. The EE Collaborative Logi…
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.

777 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