database outputs my entire page over and over

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
longhorn14
Forum Newbie
Posts: 8
Joined: Mon Aug 18, 2003 10:49 pm
Location: austin

database outputs my entire page over and over

Post by longhorn14 »

First off, thanks for helping. You can easily see my problem here:
http://www.racksandfins.com/guides.php? ... ng%20Guide

How can I get it to just output the records from the table and not reproduce the whole page for EACH record? My entire php code is pasted below. I think I am putting something in the wrong place. Any help would be awesome.
Thanks a TON,
nat

Code: Select all

<?
include("admin/customers/dbcustomers.inc.php");
mysql_connect(mysql,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM customers WHERE cust_subtype='$cust_subtype'";
$result=mysql_query($query);
$num=mysql_numrows($result); 
mysql_close();
$cust_type="contacts";


?>


<?
$i=0;
while ($i < $num) &#123;
$cust_type=mysql_result($result,$i,"cust_type");
$type_name=mysql_result($result,$i,"type_name");
$cust_subtype=mysql_result($result,$i,"cust_subtype");
$company=mysql_result($result,$i,"company");
$contact=mysql_result($result,$i,"contact");
$address=mysql_result($result,$i,"address");
$city=mysql_result($result,$i,"city"); 
$state_res=mysql_result($result,$i,"state_res"); 
$zip=mysql_result($result,$i,"zip"); 
$region=mysql_result($result,$i,"region"); 
$area=mysql_result($result,$i,"area"); 
$bus_phone=mysql_result($result,$i,"bus_phone"); 
$fax=mysql_result($result,$i,"fax"); 
$cell=mysql_result($result,$i,"cell");
$email=mysql_result($result,$i,"email"); 
$website=mysql_result($result,$i,"website"); 
$comments=mysql_result($result,$i,"comments"); 
$submitted_by=mysql_result($result,$i,"submitted_by");  
$id=mysql_result($result,$i,"id");
?>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="javascript" src="ts_files/scroll.js"></script>

<head>
<title>Hunting and Fishing Super Site</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<script language="JavaScript">
<!--
function mmLoadMenus() &#123;
  if (window.mm_menu_0722235543_0) return;
          window.mm_menu_0722235543_0 = new Menu("root",100,10,"Verdana, Arial, Helvetica, sans-serif",10,"#ffffff","#FFFFFF","#9e0021","#336600","left","middle",1,0,1000,-5,7,true,false,true,0,true,true);
  mm_menu_0722235543_0.addMenuItem("Hunting&nbsp;Gear","location='#'");
  mm_menu_0722235543_0.addMenuItem("Fishing&nbsp;Gear","location='#'");
   mm_menu_0722235543_0.hideOnMouseOut=true;
   mm_menu_0722235543_0.bgColor='#666666';
   mm_menu_0722235543_0.menuBorder=0;
   mm_menu_0722235543_0.menuLiteBgColor='#FFFFFF';
   mm_menu_0722235543_0.menuBorderBgColor='#777777';
  window.mm_menu_0724010918_0 = new Menu("root",112,12,"Verdana, Arial, Helvetica, sans-serif",10,"#ffffff","#FFFFFF","#9e0021","#336600","left","middle",1,0,1000,-5,7,true,false,true,0,true,true);
  mm_menu_0724010918_0.addMenuItem("Hunting&nbsp;Guides","location='http://www.racksandfins.com/guides.php?cust_subtype=Hunting%20Guide'");
  mm_menu_0724010918_0.addMenuItem("Fishing&nbsp;Guides","location='#'");
   mm_menu_0724010918_0.hideOnMouseOut=true;
   mm_menu_0724010918_0.bgColor='#666666';
   mm_menu_0724010918_0.menuBorder=0;
   mm_menu_0724010918_0.menuLiteBgColor='#FFFFFF';
   mm_menu_0724010918_0.menuBorderBgColor='#777777';
window.mm_menu_0714234555_2 = new Menu("root",111,12,"Verdana, Arial, Helvetica, sans-serif",10,"#ffffff","#FFFFFF","#9e0021","#336600","left","middle",1,0,1000,-5,7,true,false,true,0,false,true);
  mm_menu_0714234555_2.addMenuItem("Land","location='#'");
  mm_menu_0714234555_2.addMenuItem("Ranches&nbsp;&&nbsp;Farms","location='#'");
  mm_menu_0714234555_2.addMenuItem("Campsites","location='#'");
   mm_menu_0714234555_2.hideOnMouseOut=true;
   mm_menu_0714234555_2.bgColor='#555555';
   mm_menu_0714234555_2.menuBorder=1;
   mm_menu_0714234555_2.menuLiteBgColor='#FFFFFF';
   mm_menu_0714234555_2.menuBorderBgColor='#777777';

      window.mm_menu_0724011821_0 = new Menu("root",106,12,"Verdana, Arial, Helvetica, sans-serif",10,"#ffffff","#FFFFFF","#9e0021","#336600","left","middle",1,0,1000,-5,7,true,false,true,0,true,true);
  mm_menu_0724011821_0.addMenuItem("Tales","location='#'");
  mm_menu_0724011821_0.addMenuItem("Forums","location='http://www.racksandfins.com/phpBB2'");
  mm_menu_0724011821_0.addMenuItem("Gallery","location='#'");
  mm_menu_0724011821_0.addMenuItem("Find&nbsp;a&nbsp;Partner","location='#'");
   mm_menu_0724011821_0.hideOnMouseOut=true;
   mm_menu_0724011821_0.bgColor='#555555';
   mm_menu_0724011821_0.menuBorder=1;
   mm_menu_0724011821_0.menuLiteBgColor='#FFFFFF';
   mm_menu_0724011821_0.menuBorderBgColor='#777777';

mm_menu_0724011821_0.writeMenus();
&#125; // mmLoadMenus()
//-->
</script>
<script language="JavaScript" src="mm_menu.js"></script>
<link href="mdm.css" rel="stylesheet" type="text/css" />
<meta name="Keywords" content="hunting,fishing,angling,leases,guides,outdoors,outfitters,saltwater fishing,fresh water fishing, texas hunting, fishing guides, hunting guides, racks and fins, taxidermy, sportsman, deer hunting, hunting trips" />
</head>

<body leftmargin="2" topmargin="2" marginwidth="2" marginheight="2">
<script language="JavaScript1.2">mmLoadMenus();</script>
<table width="700" height="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#CCCC99">
  <tr>
    <td height="549" valign="top"><table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td width="126" height="507" valign="top"><table border="0" cellpadding="0" cellspacing="0" width="126">
            <tr>
              <!-- row 1 -->
              <td><table border="0" cellpadding="0" cellspacing="0" width="126">
                  <tr>
                    <td valign="top" bgcolor="#FFFFFF"><div align="center"><a href="http://www.racksandfins.com/index.htm"><img src="navslices/logo.gif" width="96" height="98" border="0" /></a></div>
                    </td>
                  </tr>
                </table>
              </td>
            </tr>
            <tr>
              <td><img src="navslices/slice_r2_c3.gif" alt="" name="slice_r2_c3" width="126" height="20" border="0" id="slice_r2_c3" /></td>
            </tr>
            <tr>
              <!-- row 2 -->
              <td><a href="#" onMouseOver="MM_showMenu(window.mm_menu_0722235543_0,126,0,null,'slice_r3_c2')" onMouseOut="MM_startTimeout();"><img src="navslices/slice_r3_c2.gif" alt="" name="slice_r3_c2" width="126" height="18" border="0" id="slice_r3_c2" /></a></td>
            </tr>
            <tr>
              <!-- row 3 -->
              <td><a href="#" onMouseOver="MM_showMenu(window.mm_menu_0724010918_0,126,0,null,'slice_r4_c2')" onMouseOut="MM_startTimeout();"><img src="navslices/slice_r4_c2.gif" alt="" name="slice_r4_c2" width="126" height="18" border="0" id="slice_r4_c2" /></a></td>
            </tr>
            <tr>
              <!-- row 4 -->
              <td><a href="#" onMouseOver="MM_showMenu(window.mm_menu_0714234555_2,126,0,null,'slice_r6_c2');" onMouseOut="MM_startTimeout();"><img src="navslices/slice_r6_c2.gif" alt="" name="slice_r6_c2" width="126" height="18" border="0" id="slice_r6_c2" /></a></td>
            </tr>
            <tr>
              <!-- row 5 -->
              <td><img src="navslices/slice_r8_c2.gif" alt="" name="slice_r8_c2" width="126" height="19" border="0" id="slice_r8_c2" /></td>
            </tr>
            <tr>
              <!-- row 6 -->
              <td><img src="navslices/slice_r11_c2.gif" alt="" name="slice_r11_c2" width="126" height="18" border="0" id="slice_r11_c2" /></td>
            </tr>
            <tr>
              <!-- row 7 -->
              <td><img src="navslices/slice_r13_c2.gif" alt="" name="slice_r13_c2" width="126" height="18" border="0" id="slice_r13_c2" /></td>
            </tr>
            <tr>
              <!-- row 8 -->
              <td><img src="navslices/slice_r15_c2.gif" alt="" name="slice_r15_c2" width="126" height="18" border="0" id="slice_r15_c2" /></td>
            </tr>
            <tr>
              <!-- row 9 -->
              <td><img src="navslices/slice_r17_c2.gif" alt="" name="slice_r17_c2" width="126" height="18" border="0" id="slice_r17_c2" /></td>
            </tr>
            <tr>
              <!-- row 10 -->
              <td><img src="navslices/slice_r19_c2.gif" alt="" name="slice_r19_c2" width="126" height="18" border="0" id="slice_r19_c2" /></td>
            </tr>
            <tr>
              <td><img src="navslices/slice_r20_c3.gif" alt="" name="slice_r20_c3" width="126" height="20" border="0" id="slice_r20_c3" /></td>
            </tr>
            <tr>
              <!-- row 11 -->
              <td width="126" height="171" valign="top" bgcolor="#CCCC99"><p><a href="http://www.fishgalveston.com" target="_blank"><img src="images/ad_fishgalveston.jpg" width="125" height="135" border="0" /><br />
                </a></p>
              </td>
            </tr>
          </table>
        </td>
        <td valign="top"><table width="100%" border="0" align="left" cellpadding="0" cellspacing="0" bgcolor="#CCCC99">
            <tr>
              <td colspan="5"><img src="navslices/topNav.gif" width="100%" height="15" /></td>
            </tr>
            <tr>
              <td width="43">&nbsp;&nbsp;&nbsp;</td>
              <td width="234"><a href="http://www.aceintheholeguideservice.com/" target="_blank"><img src="navslices/ad-ace.gif" width="234" height="60" border="0" /></a></td>
              <td width="36">&nbsp;</td>
              <td width="216"><img src="navslices/dummyad.gif" width="234" height="60" /></td>
              <td width="44">&nbsp;</td>
            </tr>
            <tr>
              <td height="23">&nbsp;</td>
              <td>&nbsp;</td>
              <td>&nbsp;</td>
              <td>&nbsp;</td>
              <td>&nbsp;</td>
            </tr>
            <tr bgcolor="#333333">
              <td height="20">&nbsp;</td>
              <td colspan="3"><img src="navslices/topnavAboutUs.gif" width="78" height="20" /><a href="mailto:info@racksandfins.com"><img src="navslices/topnavContactUs.gif" width="78" height="20" border="0" /></a><img src="navslices/topnavAdvertise.gif" width="78" height="20" /><a href="javascript:;" onMouseOver="MM_showMenu(window.mm_menu_0724011821_0,0,20,null,'image1')" onMouseOut="MM_startTimeout();"><img src="navslices/topnavCommunity.gif" name="image1" width="78" height="20" border="0" id="image1" /></a></td>
              <td><div align="right"><img src="navslices/topNavRoundRt.gif" width="38" height="20" /></div>
              </td>
            </tr>
            <tr bgcolor="#CCCC99">
              <td height="20" colspan="5"> <br />
                  <table width="95%" height="101" border="0" align="center" cellpadding="0" cellspacing="0">
                    <tr> 
                      <td width="1" height="19">&nbsp;</td>
                    </tr>
                    <tr> 
                      <td height="42"><table width="99%" border="0" align="center" cellpadding="0" cellspacing="2" class="FORMlive">
                          <tr> 
                            <td colspan="2"><strong><? echo "$cust_subtype"; ?></strong></td>
                            <td colspan="2" nowrap>&nbsp;</td>
                            <td colspan="2">&nbsp;</td>
                          </tr>
                          <tr> 
                            <td width="125"></td>
                            <td width="149"></td>
                            <td width="67"></td>
                            <td width="144"></td>
                            <td width="24"></td>
                            <td width="147"></td>
                          </tr>
                          <tr> 
                            <td height="20" valign="middle"> <div align="right"><strong>Business/Company</strong></div></td>
                            <td><? echo "$company"; ?></td>
                            <td><div align="right"><strong>Contact</strong></div></td>
                            <td colspan="3"><? echo "$contact"; ?></td>
                          </tr>
                          <tr> 
                            <td height="20" valign="middle"> <div align="right"><strong>Address</strong></div></td>
                            <td><? echo "$address"; ?></td>
                            <td><div align="right"><strong>City/State</strong></div></td>
                            <td valign="middle"><? echo "$city"; ?> <? echo "$state_res"; ?></td>
                            <td><div align="right"><strong>Zip</strong></div></td>
                            <td><? echo "$zip"; ?></td>
                          </tr>
                          <tr> 
                            <td valign="middle"> <div align="right"></div></td>
                            <td>&nbsp;</td>
                            <td><div align="right"></div></td>
                            <td>&nbsp;</td>
                            <td><div align="right"></div></td>
                            <td>&nbsp;</td>
                          </tr>
                          <tr> 
                            <td height="20" valign="middle"> <div align="right"><strong>Region</strong></div></td>
                            <td><? echo "$region"; ?></td>
                            <td><div align="right"><strong>Area</strong></div></td>
                            <td><? echo "$area"; ?></td>
                            <td><div align="right"></div></td>
                            <td>&nbsp;</td>
                          </tr>
                          <tr> 
                            <td height="15" valign="middle"> <div align="right"></div></td>
                            <td>&nbsp;</td>
                            <td><div align="right"></div></td>
                            <td>&nbsp;</td>
                            <td><div align="right"></div></td>
                            <td>&nbsp;</td>
                          </tr>
                          <tr> 
                            <td height="20" valign="middle"> <div align="right"><strong>Business 
                                Phone</strong></div></td>
                            <td><? echo "$bus_phone"; ?></td>
                            <td><div align="right"><strong>Fax</strong></div></td>
                            <td><? echo "$fax"; ?></td>
                            <td><div align="right"><strong>Cell</strong></div></td>
                            <td><? echo "$cell"; ?></td>
                          </tr>
                          <tr> 
                            <td height="20" valign="middle"> <div align="right"><strong>Email</strong></div></td>
                            <td><? echo "$email"; ?></td>
                            <td><div align="right"><strong>Website</strong></div></td>
                            <td colspan="3"><? echo "$website"; ?></td>
                          </tr>
                          <br>
                          <hr align="center" width="40%">
                          <br>

                        </table></td>
                    </tr>
                    <tr> 
                      <td height="19">&nbsp;</td>
                    </tr>
                    <tr> 
                      <td height="19">&nbsp;</td>
                    </tr>
                  </table>
                  <div align="center"></div>
                  <table height="29" border="0" cellpadding="0" cellspacing="0">
                    <tr> 
                      <td width="1" height="19">&nbsp;</td>
                    </tr>
                    <tr> 
                      <td height="10">&nbsp;</td>
                    </tr>
                  </table>
              </td>
            </tr>
          </table>
        </td>
        <td valign="middle" bgcolor="#FFFFFF"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="rightAds">
            <tr><img src="images/advertisement.gif" /></tr>
            <tr>
              <td><a href="http://www.ybarranch.com/" target="_blank"><img src="navslices/spacer.gif" width="120" height="240" border="0" align="middle" /></a></td>
            </tr>
            <tr> </tr>
          </table>
        </td>
      </tr>
    </table></td>
  </tr>
</table>

<table width="700" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><div align="center">Please contact us at <a href="mailto:info@racksandfins.com">info@racksandfins.com</a></div></td>
  </tr>
</table>
<p>&nbsp;</p>
</body>
</html>
                          <?
++$i;
&#125; 


?>
User avatar
Stoker
Forum Regular
Posts: 782
Joined: Thu Jan 23, 2003 9:45 pm
Location: SWNY
Contact:

Post by Stoker »

the while loop needs to enclose the inner table that your are populating and not the whole html document.

move the while () { and } to enclose that table.
longhorn14
Forum Newbie
Posts: 8
Joined: Mon Aug 18, 2003 10:49 pm
Location: austin

Post by longhorn14 »

Thanks! You taught me something I didn't learn on my own. I appreciate it.
Thank you.
nat
Post Reply