MOUSE SCROLLING WEHN USING THIS PHP CODE. (VERSION 2)

rleahong · June 28, 2013

THE MOUSE IS SCROLLING WHEN CODE IS ADDED IN INNER LOOP BELOW THE

$ORDER OBJECT

<?php
 PRINT_ROYALTY_ORDERS();
function PRINT_ROYALTY_ORDERS(){

 $hostname ="localhost";
 $password ="";
 $username ="root";
 $CON =mysql_connect ($hostname, $username, $password) ;
 mysql_select_db("reggaedbf", $CON);
 $SQLALBUM = " SELECT * FROM ALBUM ";
 $FALBUM = mysql_query( $SQLALBUM, $CON );
 while ( $ALBUM = mysql_fetch_object( $FALBUM )){
 $ALBUMCOD = $ALBUM->ALBUMCOD;
 $ALBUMNAM = $ALBUM->ALBUMNAM;

############################################################################
 ?>
 <TABLE WIDTH="700">
 <TR>
 <TH BGCOLOR="#0000FF" WIDTH="10%" ALIGN="CENTER"><?php echo( " ORDER NO. " ) ?></TH>
 <TH BGCOLOR="#00FFFF" WIDTH="10%" ALIGN="CENTER"><?php echo( " ORDER DATE " ) ?></TH>
 <TH BGCOLOR="#0000FF" WIDTH="20%" ALIGN="CENTER"><?php echo( " ACCOUNT NAME " ) ?></TH>
 <TH BGCOLOR="#00FFFF" WIDTH="20%" ALIGN="CENTER"><?php echo( " STREET " ) ?></TH>
 <TH BGCOLOR="#0000FF" WIDTH="20%" ALIGN="CENTER"><?php echo( " COUNTRY " ) ?></TH>
 <TH BGCOLOR="#00FFFF" WIDTH="10%" ALIGN="CENTER"><?php echo( " STATE " ) ?></TH>
 <TH BGCOLOR="#0000FF" WIDTH="10%" ALIGN="CENTER"><?php echo( " CITY " ) ?></TH>
 </TR>
 <?php

#############################################################################

             $SQLORDERS = " SELECT * FROM ORDERS ";
              $SQLORDERS.= " WHERE   ITEMNO=" . $ALBUMCOD;
             $FORDERS = mysql_query( $SQLORDERS, $CON );
             $MATCHES   = mysql_num_rows( $FORDERS );
              if ( $MATCHES == 0 ){
              }
             else {

                           while ( $ORDER = mysql_fetch_object( $FORDERS )){
                                        $ACCOUNT_NAME=$ORDER->ACCOUNT_NAME;
                                        $ORDDAT          = $ORDER->ORDDAT;
                                       $COUNTRYCOD = $ORDER->COUNTRYCOD;
                                       $STATECOD     = $ORDER->STATECOD;
                                       $CITYCOD        = $ORDER->CITYCOD;
                                        $STREET          = $ORDER->STREET;
                                      $AMOUNT         = $ORDER->AMOUNT;
                                        $ORDERNO   = $ORDER->ORDERNO;
                                      $SQLCOUNTRY = " SELECT * FROM COUNTRY ";
                                       $SQLCOUNTRY.= " WHERE COUNTRYCOD=" . $COUNTRYCOD;
                                      $FCOUNTRY   = mysql_query( $SQLCOUNTRY, $CON );
                                        $MATCHES    = mysql_num_rows( $FCOUNTRY );
                                         if ( $MATCHES == 0 ){
                                       }
                                        else {
                                                      $ROW        = mysql_fetch_array($FCOUNTRY );
                                                     $COUNTRYNAM = $ROW["COUNTRYNAM"];
                                         }
                                          $SQLSTATES = " SELECT * FROM STATEFIL ";
                                          $SQLSTATES.= " WHERE COUNTRYCOD=" . $COUNTRYCOD ;
                                           $SQLSTATES.= " AND      STATECOD=" . $STATECOD;
                                          $FSTATES   = mysql_query( $SQLSTATES, $CON );
                                           $ROW       = mysql_fetch_array($FSTATES );
                                          $STATENAM = $ROW["STATENAM"];
                                           $SQLCITIES = " SELECT * FROM CITYFIL ";
                                           $SQLCITIES.= " WHERE COUNTRYCOD=" . $COUNTRYCOD ;
                                          $SQLCITIES.= " AND      STATECOD=" . $STATECOD;
                                           $SQLCITIES.= " AND       CITYCOD=" . $CITYCOD;
                                          $FCITY     = mysql_query( $SQLCITIES, $CON );
                                          $ROW       = mysql_fetch_array($FCITY );
                                           $CITYNAM   = $ROW["CITYNAM"];

###############################################################################
 ?>
 <TR>
 <TD BGCOLOR="#0000FF" WIDTH="10%" ALIGN="CENTER"><?php echo( $ORDERNO ) ?></TD>
 <TD BGCOLOR="#00FFFF" WIDTH="10%" ALIGN="CENTER"><?php echo( $ORDERDATE ) ?></TD>
 <TD BGCOLOR="#0000FF" WIDTH="20%" ALIGN="CENTER"><?php echo( $ACCOUNT_NAME ) ?></TD>
 <TD BGCOLOR="#00FFFF" WIDTH="20%" ALIGN="CENTER"><?php echo( $STREET ) ?></TD>
 <TD BGCOLOR="#0000FF" WIDTH="20%" ALIGN="CENTER"><?php echo( $COUNTRYNAM ) ?></TD>
 <TD BGCOLOR="#00FFFF" WIDTH="10%" ALIGN="CENTER"><?php echo( $STATENAM ) ?></TD>
 <TD BGCOLOR="#0000FF" WIDTH="10%" ALIGN="CENTER"><?php echo( $CITYNAM ) ?></TD>
 </TR>
############################################################################

<?php

 }
 ?>
 </TABLE>
 <?php
 }
 }
}

?>

trq · June 28, 2013

You have to be kidding.

See http://www.catb.org/esr/faqs/smart-questions.html

ginerjm · June 29, 2013

OP: Something I just have to ask. Whatever do you MEAN when you say "the mouse is scrolling"? Could it be that your code is just generating so much data that your page is just spitting out line after line after line?

trq: love that link!

rleahong · August 4, 2013

"when I say , mouse is scrolling " I mean for example

the mouse is scrolling when many applications are in the processor queue or when application occupies most of memory.

Edited August 4, 2013 by rleahong

KevinM1 · August 4, 2013

"when I say , mouse is scrolling " I mean for example

the mouse is scrolling when many applications are in the processor queue or when application occupies most of memory.

Still vague.

And, next time, please put any code you post here in

tags. You can do it easily by clicking on the <> button on our editor.

kicken · August 4, 2013

My best guess at what you mean by the mouse is scrolling is that you get a busy cursor like the application froze. Beyond that I don't really have any idea what you mean. I see you are doing queries within loops which you should not be doing, use a JOIN instead. Perhaps that will solve your problem.

rleahong · August 5, 2013

OP: Something I just have to ask. Whatever do you MEAN when you say "the mouse is scrolling"? Could it be that your code is just generating so much data that your page is just spitting out line after line after line?

trq: love that link!

THE MOUSE IS SCROLLING WHEN CODE IS ADDED IN INNER LOOP BELOW THE

$ORDER OBJECT

<?php

 PRINT_ROYALTY_ORDERS();

function PRINT_ROYALTY_ORDERS(){



 $hostname ="localhost";

 $password ="";

 $username ="root";

 $CON =mysql_connect ($hostname, $username, $password) ;

 mysql_select_db("reggaedbf", $CON);

 $SQLALBUM = " SELECT * FROM ALBUM ";

 $FALBUM = mysql_query( $SQLALBUM, $CON );

 while ( $ALBUM = mysql_fetch_object( $FALBUM )){

 $ALBUMCOD = $ALBUM->ALBUMCOD;

 $ALBUMNAM = $ALBUM->ALBUMNAM;

############################################################################

 ?>

 <TABLE WIDTH="700">

 <TR>

 <TH BGCOLOR="#0000FF" WIDTH="10%" ALIGN="CENTER"><?php echo( " ORDER NO. " ) ?></TH>

 <TH BGCOLOR="#00FFFF" WIDTH="10%" ALIGN="CENTER"><?php echo( " ORDER DATE " ) ?></TH>

 <TH BGCOLOR="#0000FF" WIDTH="20%" ALIGN="CENTER"><?php echo( " ACCOUNT NAME " ) ?></TH>

 <TH BGCOLOR="#00FFFF" WIDTH="20%" ALIGN="CENTER"><?php echo( " STREET " ) ?></TH>

 <TH BGCOLOR="#0000FF" WIDTH="20%" ALIGN="CENTER"><?php echo( " COUNTRY " ) ?></TH>

 <TH BGCOLOR="#00FFFF" WIDTH="10%" ALIGN="CENTER"><?php echo( " STATE " ) ?></TH>

 <TH BGCOLOR="#0000FF" WIDTH="10%" ALIGN="CENTER"><?php echo( " CITY " ) ?></TH>

 </TR>

 <?php

#############################################################################

 $SQLORDERS = " SELECT * FROM ORDERS ";

 $SQLORDERS.= " WHERE ITEMNO=" . $ALBUMCOD;

 $FORDERS = mysql_query( $SQLORDERS, $CON );

 $MATCHES = mysql_num_rows( $FORDERS );

 if ( $MATCHES == 0 ){

 }

 else {



 while ( $ORDER = mysql_fetch_object( $FORDERS )){

 $ACCOUNT_NAME=$ORDER->ACCOUNT_NAME;

 $ORDDAT = $ORDER->ORDDAT;

 $COUNTRYCOD = $ORDER->COUNTRYCOD;

 $STATECOD = $ORDER->STATECOD;

 $CITYCOD = $ORDER->CITYCOD;

 $STREET = $ORDER->STREET;

 $AMOUNT = $ORDER->AMOUNT;

 $ORDERNO = $ORDER->ORDERNO;

 $SQLCOUNTRY = " SELECT * FROM COUNTRY ";

 $SQLCOUNTRY.= " WHERE COUNTRYCOD=" . $COUNTRYCOD;

 $FCOUNTRY = mysql_query( $SQLCOUNTRY, $CON );

 $MATCHES = mysql_num_rows( $FCOUNTRY );

 if ( $MATCHES == 0 ){

 }

 else {

 $ROW = mysql_fetch_array($FCOUNTRY );

 $COUNTRYNAM = $ROW["COUNTRYNAM"];

 }

 $SQLSTATES = " SELECT * FROM STATEFIL ";

 $SQLSTATES.= " WHERE COUNTRYCOD=" . $COUNTRYCOD ;

 $SQLSTATES.= " AND STATECOD=" . $STATECOD;

 $FSTATES = mysql_query( $SQLSTATES, $CON );

 $ROW = mysql_fetch_array($FSTATES );

 $STATENAM = $ROW["STATENAM"];

 $SQLCITIES = " SELECT * FROM CITYFIL ";

 $SQLCITIES.= " WHERE COUNTRYCOD=" . $COUNTRYCOD ;

 $SQLCITIES.= " AND STATECOD=" . $STATECOD;

 $SQLCITIES.= " AND CITYCOD=" . $CITYCOD;

 $FCITY = mysql_query( $SQLCITIES, $CON );

 $ROW = mysql_fetch_array($FCITY );

 $CITYNAM = $ROW["CITYNAM"];

###############################################################################

 ?>

 <TR>

 <TD BGCOLOR="#0000FF" WIDTH="10%" ALIGN="CENTER"><?php echo( $ORDERNO ) ?></TD>

 <TD BGCOLOR="#00FFFF" WIDTH="10%" ALIGN="CENTER"><?php echo( $ORDERDATE ) ?></TD>

 <TD BGCOLOR="#0000FF" WIDTH="20%" ALIGN="CENTER"><?php echo( $ACCOUNT_NAME ) ?></TD>

 <TD BGCOLOR="#00FFFF" WIDTH="20%" ALIGN="CENTER"><?php echo( $STREET ) ?></TD>

 <TD BGCOLOR="#0000FF" WIDTH="20%" ALIGN="CENTER"><?php echo( $COUNTRYNAM ) ?></TD>

 <TD BGCOLOR="#00FFFF" WIDTH="10%" ALIGN="CENTER"><?php echo( $STATENAM ) ?></TD>

 <TD BGCOLOR="#0000FF" WIDTH="10%" ALIGN="CENTER"><?php echo( $CITYNAM ) ?></TD>

 </TR>

############################################################################

 <?php



 }

 ?>

 </TABLE>

 <?php

 }

 }

}

?>

jazzman1 · August 5, 2013

Buy a new mouse or a new machine.

How old is your computer?

Edited August 5, 2013 by jazzman1

Sign In

MOUSE SCROLLING WEHN USING THIS PHP CODE. (VERSION 2)

Recommended Posts

rleahong

Link to comment

Share on other sites

trq

Link to comment

Share on other sites

ginerjm

Link to comment

Share on other sites

rleahong

Link to comment

Share on other sites

KevinM1

Link to comment

Share on other sites

kicken

Link to comment

Share on other sites

rleahong

Link to comment

Share on other sites

jazzman1

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information