PHP CODE Causing Mouse Scrolling

rleahong · June 25, 2013

the code in the inner loop are causing the mouse to scroll.

<?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
 }
 }
}

?>

ginerjm · June 25, 2013

What inner loop? If you are positive that is the area with a problem, why give us so much to search thru?

PS - your html could seriously use some CSS to clean it up! Do you really think you have to write all those style attributes into every <td> tag??

Sign In

PHP CODE Causing Mouse Scrolling

Recommended Posts

rleahong

Link to comment

Share on other sites

ginerjm

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information