Jump to content


Photo

MySQL Checking or w/e


  • Please log in to reply
2 replies to this topic

#1 Imtehbegginer

Imtehbegginer
  • Members
  • PipPipPip
  • Advanced Member
  • 53 posts

Posted 26 October 2006 - 11:55 PM

Here is my code
<HTML>
<HEAD>
<TITLE><?php include 'config.php';
echo $config['servname'];?></TITLE> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> 
<LINK REL="stylesheet" HREF="styles/style.css" TYPE="text/css">
<style type="text/css">
<!--
.style1 {color: #999999}
-->
</style>
</HEAD>

<BODY BGCOLOR="323232" TEXT="#000000" LEFTMARGIN="0" TOPMARGIN="0" MARGINWIDTH="0" MARGINHEIGHT="0">
<TABLE WIDTH="10%" BORDER="0" CELLSPACING="0" CELLPADDING="0" ALIGN="CENTER"><TR><TD><IMG SRC="images/interface_01.gif" WIDTH="800" HEIGHT="110"></TD></TR><TR><TD><TABLE WIDTH="100%" BORDER="0" CELLSPACING="0" CELLPADDING="0"><TR><TD BGCOLOR="494E52" WIDTH="4%" BACKGROUND="images/interface_11.gif" VALIGN="TOP"><TABLE WIDTH="0%" BORDER="0" CELLSPACING="0" CELLPADDING="0"><TR><TD><IMG SRC="images/interface_02.gif" WIDTH="163" HEIGHT="20"></TD></TR><TR><TD BACKGROUND="images/interface_05.gif"><TABLE WIDTH="81%" BORDER="0" CELLSPACING="0" CELLPADDING="0" ALIGN="RIGHT"><TR>
  <TD CLASS="text1"><A HREF="index.php">Home</A></TD>
</TR><TR>
  <TD CLASS="text1"><A HREF="<?php include 'config.php';
  echo $config['forum'];?>">Forums</A></TD>
</TR><TR>
  <TD CLASS="text1"><A HREF="rankings.php">Rankings</A></TD>
</TR><TR>
  <TD CLASS="text1"><A HREF="download.php" target="_self">Downloads</A></TD>
</TR><TR>
  <TD CLASS="text1"><A HREF="stats.php">Statistics</A></TD>
</TR></TABLE></TD></TR><TR><TD><IMG SRC="images/interface_06.gif" WIDTH="163" HEIGHT="22"></TD></TR><TR><TD BACKGROUND="images/interface_07.gif">&nbsp;</TD></TR><TR><TD><IMG SRC="images/interface_08.gif" WIDTH="163" HEIGHT="28"></TD></TR><TR><TD BACKGROUND="images/interface_09.gif"><TABLE WIDTH="81%" BORDER="0" CELLSPACING="0" CELLPADDING="0" ALIGN="RIGHT"><TR>
  <TD CLASS="text1"><A HREF="usercp.php">Members Area </A></TD>
</TR><TR>
  <TD CLASS="text1"><A HREF="admincp.php">Admin Area </A></TD>
</TR><TR>
  <TD CLASS="text1"><A HREF="register.php">Register</A></TD>
</TR><TR>
  <TD CLASS="text1"><A HREF="cpass.php">Change Password </A></TD>
</TR><TR>
  <TD CLASS="text1"><A HREF="rpass.php">Recover Password </A></TD>
</TR></TABLE></TD></TR><TR><TD BACKGROUND="images/interface_09.gif"><IMG SRC="images/interface_10.gif" WIDTH="163" HEIGHT="20"></TD></TR><TR><TD BACKGROUND="images/interface_11.gif">&nbsp;</TD></TR></TABLE></TD><TD WIDTH="89%" BGCOLOR="494E52" VALIGN="TOP"><DIV ALIGN="CENTER"><SPAN CLASS="pagehead"> 
<BR> HOME</SPAN><BR><BR></DIV><TABLE CELLPADDING="1" CELLSPACING="0" BORDER="0" BGCOLOR="#000000" WIDTH="266" HEIGHT="25" ALIGN="CENTER"> 
<TR> <TD WIDTH="264"><TABLE CELLPADDING="1" CELLSPACING="0" BORDER="0" BGCOLOR="7E9AB8" WIDTH="159" HEIGHT="25"> 
<TR> <TD WIDTH="157" BGCOLOR="737C83"> <TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0" BGCOLOR="#ffffff" WIDTH="391"> 
<TR> <TD HEIGHT="45" BGCOLOR="5C6368"><DIV ALIGN="CENTER"><BR><TABLE WIDTH="94%" BORDER="0" CELLSPACING="0" CELLPADDING="0"><TR>
  <TD CLASS="news"><p>Server Rankings </p>    </TD>
</TR><TR>
  <TD CLASS="pagehead">
    <table width="302" height="115" border="0" align="center" class="text1">
      <tr>
        <td width="80"><span class="style1">Name</span></td>
        <td width="64"><span class="style1">Level</span></td>
        <td width="51"><span class="style1">Zuly</span></td>
        <td width="79"><span class="style1">Class</span></td>
      </tr>
      <tr>
        <td height="29"><?php
		include 'config.php';
$result = mysql_query("SELECT level, char_name, zuly, classid FROM characters ORDER BY level DESC") 
or die(mysql_error());  

// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
	// Print out the contents of each row into a table
	echo $row['char_name'];
	include ('modules/class.php');
	echo "</td></tr>"; 
} 
?>&nbsp;</td>
        <td>&nbsp;</td>
        <td><?php
		
		include 'config.php';
$result = mysql_query("SELECT level, char_name, zuly, classid FROM characters ORDER BY level DESC") 
or die(mysql_error());  

// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
	// Print out the contents of each row into a table
	echo $row['level'];
	include ('modules/class.php');
	echo "</td></tr>"; 
} 
?></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
    </table>
    <br></TD>
</TR></TABLE>
      <BR>
<BR></DIV></TD></TR> </TABLE></TD></TR> </TABLE></TD></TR> 
</TABLE><BR><BR>
<BR>
<BR><BR><BR><BR><BR><BR><BR></TD><TD WIDTH="7%" BACKGROUND="images/interface_04.gif" VALIGN="TOP"><IMG SRC="images/interface_04.gif" WIDTH="52" HEIGHT="10"></TD></TR></TABLE></TD></TR><TR><TD><img src="images/interface_12.gif" width="800" height="71" border="0" usemap="#Map">
    <map name="Map">
      <area shape="rect" coords="652,54,769,84" href="http://www.clantemplates.com" target="_blank">
    </map>
    </TD>
</TR></TABLE>
</BODY>
</HTML>

But Im only getting the FIRST row.. how can I get the 2nd, third, fourth and so on?

#2 btherl

btherl
  • Staff Alumni
  • Advanced Member
  • 3,893 posts
  • LocationAustralia

Posted 27 October 2006 - 02:29 AM

Are you getting only one row, or are you getting the same row printed multiple times?  Your loops looks like they should work, assuming class.php does something sensible.

#3 redarrow

redarrow
  • Members
  • PipPipPip
  • Advanced Member
  • 7,308 posts
  • Locationlondon

Posted 27 October 2006 - 07:14 AM

I get the inpression that it's the query and you useing array and not assoc

Try this ok.

<HTML>
<HEAD>
<TITLE><?php include 'config.php';
echo $config['servname'];?></TITLE> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> 
<LINK REL="stylesheet" HREF="styles/style.css" TYPE="text/css">
<style type="text/css">
<!--
.style1 {color: #999999}
-->
</style>
</HEAD>

<BODY BGCOLOR="323232" TEXT="#000000" LEFTMARGIN="0" TOPMARGIN="0" MARGINWIDTH="0" MARGINHEIGHT="0">
<TABLE WIDTH="10%" BORDER="0" CELLSPACING="0" CELLPADDING="0" ALIGN="CENTER"><TR><TD><IMG SRC="images/interface_01.gif" WIDTH="800" HEIGHT="110"></TD></TR><TR><TD><TABLE WIDTH="100%" BORDER="0" CELLSPACING="0" CELLPADDING="0"><TR><TD BGCOLOR="494E52" WIDTH="4%" BACKGROUND="images/interface_11.gif" VALIGN="TOP"><TABLE WIDTH="0%" BORDER="0" CELLSPACING="0" CELLPADDING="0"><TR><TD><IMG SRC="images/interface_02.gif" WIDTH="163" HEIGHT="20"></TD></TR><TR><TD BACKGROUND="images/interface_05.gif"><TABLE WIDTH="81%" BORDER="0" CELLSPACING="0" CELLPADDING="0" ALIGN="RIGHT"><TR>
  <TD CLASS="text1"><A HREF="index.php">Home</A></TD>
</TR><TR>
  <TD CLASS="text1"><A HREF="<?php include 'config.php';
  echo $config['forum'];?>">Forums</A></TD>
</TR><TR>
  <TD CLASS="text1"><A HREF="rankings.php">Rankings</A></TD>
</TR><TR>
  <TD CLASS="text1"><A HREF="download.php" target="_self">Downloads</A></TD>
</TR><TR>
  <TD CLASS="text1"><A HREF="stats.php">Statistics</A></TD>
</TR></TABLE></TD></TR><TR><TD><IMG SRC="images/interface_06.gif" WIDTH="163" HEIGHT="22"></TD></TR><TR><TD BACKGROUND="images/interface_07.gif">&nbsp;</TD></TR><TR><TD><IMG SRC="images/interface_08.gif" WIDTH="163" HEIGHT="28"></TD></TR><TR><TD BACKGROUND="images/interface_09.gif"><TABLE WIDTH="81%" BORDER="0" CELLSPACING="0" CELLPADDING="0" ALIGN="RIGHT"><TR>
  <TD CLASS="text1"><A HREF="usercp.php">Members Area </A></TD>
</TR><TR>
  <TD CLASS="text1"><A HREF="admincp.php">Admin Area </A></TD>
</TR><TR>
  <TD CLASS="text1"><A HREF="register.php">Register</A></TD>
</TR><TR>
  <TD CLASS="text1"><A HREF="cpass.php">Change Password </A></TD>
</TR><TR>
  <TD CLASS="text1"><A HREF="rpass.php">Recover Password </A></TD>
</TR></TABLE></TD></TR><TR><TD BACKGROUND="images/interface_09.gif"><IMG SRC="images/interface_10.gif" WIDTH="163" HEIGHT="20"></TD></TR><TR><TD BACKGROUND="images/interface_11.gif">&nbsp;</TD></TR></TABLE></TD><TD WIDTH="89%" BGCOLOR="494E52" VALIGN="TOP"><DIV ALIGN="CENTER"><SPAN CLASS="pagehead"> 
<BR> HOME</SPAN><BR><BR></DIV><TABLE CELLPADDING="1" CELLSPACING="0" BORDER="0" BGCOLOR="#000000" WIDTH="266" HEIGHT="25" ALIGN="CENTER"> 
<TR> <TD WIDTH="264"><TABLE CELLPADDING="1" CELLSPACING="0" BORDER="0" BGCOLOR="7E9AB8" WIDTH="159" HEIGHT="25"> 
<TR> <TD WIDTH="157" BGCOLOR="737C83"> <TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0" BGCOLOR="#ffffff" WIDTH="391"> 
<TR> <TD HEIGHT="45" BGCOLOR="5C6368"><DIV ALIGN="CENTER"><BR><TABLE WIDTH="94%" BORDER="0" CELLSPACING="0" CELLPADDING="0"><TR>
  <TD CLASS="news"><p>Server Rankings </p>    </TD>
</TR><TR>
  <TD CLASS="pagehead">
    <table width="302" height="115" border="0" align="center" class="text1">
      <tr>
        <td width="80"><span class="style1">Name</span></td>
        <td width="64"><span class="style1">Level</span></td>
        <td width="51"><span class="style1">Zuly</span></td>
        <td width="79"><span class="style1">Class</span></td>
      </tr>
      <tr>
        <td height="29"><?php
		include 'config.php';
$result = mysql_query("SELECT characters.level, characters.char_name, characters.zuly, characters.classid FROM characters ORDER BY level DESC") 
or die(mysql_error());  

// keeps getting the next row until there are no more to get
while($row = mysql_fetch_assoc( $result )) {
	// Print out the contents of each row into a table
	echo $row['char_name'];
	include ('modules/class.php');
	echo "</td></tr>"; 
} 
?>&nbsp;</td>
        <td>&nbsp;</td>
        <td><?php
		
		include 'config.php';
$result = mysql_query("SELECT characters.level, characters.char_name, characters.zuly, characters.classid FROM characters ORDER BY level DESC") 
or die(mysql_error());  

// keeps getting the next row until there are no more to get
while($row = mysql_fetch_assoc( $result )) {
	// Print out the contents of each row into a table
	echo $row['level'];
	include ('modules/class.php');
	echo "</td></tr>"; 
} 
?></td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
    </table>
    <br></TD>
</TR></TABLE>
      <BR>
<BR></DIV></TD></TR> </TABLE></TD></TR> </TABLE></TD></TR> 
</TABLE><BR><BR>
<BR>
<BR><BR><BR><BR><BR><BR><BR></TD><TD WIDTH="7%" BACKGROUND="images/interface_04.gif" VALIGN="TOP"><IMG SRC="images/interface_04.gif" WIDTH="52" HEIGHT="10"></TD></TR></TABLE></TD></TR><TR><TD><img src="images/interface_12.gif" width="800" height="71" border="0" usemap="#Map">
    <map name="Map">
      <area shape="rect" coords="652,54,769,84" href="http://www.clantemplates.com" target="_blank">
    </map>
    </TD>
</TR></TABLE>
</BODY>
</HTML>

Wish i new all about php DAM i will have to learn
((EMAIL CODE THAT WORKS))
http://simpleforum.ath.cx/mail2.inc
((PAYPAL INTEGRATION THAT WORKS))
http://simpleforum.a...aypal1_info.inc




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users