Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

need to know why its not displaying data

Posted on 2006-10-20
2
Medium Priority
?
161 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 1500 total points
ID: 17777731
Since you fix the problem yourself you can ask a moderator to reimburse your points.

Gamebits
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Most of the sites are being standardized with W3C Web Standards. W3C provides lot of web standard services to the web. They have the web specification, process and documentation for all the web standards. You can apply HTML, CSS and Accessibility st…
Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Suggested Courses

885 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