Solved

need to know why its not displaying data

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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

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…
It's sometimes a bit tricky to use date functions in Oracle BPEL. I'll explain quickly how you can add N days to the current date. In a BPEL process this can be useful, and you can adapt it to fit your needs. First of all, let's see how to add 1 …
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now