Can you help me figure out how to do this? Here is what I have at the moment:
Code: Select all
<?php
include("connect.php");
$link=mysql_connect($host,$user,$password);
mysql_select_db($db);
include("header.php");
echo "<table border="0" cellpadding="0" cellspacing="0" width="288">\n";
echo " <tr><td width="288" valign="top"><div class="mainsmalltypenopad"><b>Player Profile</b><br><br></div></td></tr>\n";
echo "</table>\n";
/* ########Page Numbering Setup######
$pages = mysql_num_rows(mysql_query("SELECT player_id FROM $player_table"));
if(!$show) $show="1";
$perpage="5";
############################## */
$read_message="SELECT * FROM $player_table ORDER BY player_name ASC LIMIT";
$read_message_result=mysql_query($read_message);
//while($data=mysql_fetch_array($read_message_result))
{
########Layout ######
$dataїtopic]= substr("$dataїtitle]",0,36);
$dataїplayer_name]= substr("$dataїplayer_name]",0,36);
###################
echo " <table width="75%" border="1" cellspacing="0" cellpadding="0">";
echo " <tr>";
echo " <td colspan="2"><strong>$dataїplayer_name] :: <a href="mailto:$dataїplayer_email]">Contact</a>";
echo " :: <a href="$dataїplayer_msngr]">MSN</a> :: <a href="aim:goim?screenname=$dataїplayer_aim]&message=Hello+Are+you+there?">AIM</a>";
echo " :: <a href="http://wwp.icq.com/scripts/search.dll?to=$dataїplayer_icq]">ICQ</a></strong></td>";
echo " </tr>";
echo " <tr> ";
echo " <td>Realm:</td>";
echo " <td>$dataїplayer_realm]</td>";
echo " </tr>";
echo " <tr>";
echo " <td>Division:</td>";
echo " <td>$dataїplayer_division]</td>";
echo " </tr>";
echo " <tr> ";
echo " <td>Profile:</td>";
echo " <td> $dataїplayer_info]</td>";
echo " </tr>";
echo " <tr> ";
echo " <td>Games: </td>";
echo " <td>$dataїplayer_games]</td>";
echo " </tr>";
echo " <tr> ";
echo " <td>Wins: </td>";
echo " <td>$dataїplayer_wins]</td>";
echo " </tr>";
echo " <tr> ";
echo " <td>Losses: </td>";
echo " <td>$dataїplayer_losses]</td>";
echo " </tr>";
echo " </table>";
}
/* ########Page Numbering Output######
echo "<table width="500" cellspacing="0" cellpadding="0" border="0">\n";
echo " <tr><td>";
if($pages>$perpage) {
$seiten= $pages/$perpage;
if($pages%$perpage) {
$seiten++;
}
}
for ($i=1;$i<=$seiten;$i++) {
$fwd=($i-1)*$perpage;
echo "ї<a href="profile.php?show=$fwd">$i</a>]";
}
echo "</td></tr>\n";
echo "</table>\n";
###############################
mysql_close($link);
include("footer.php");
?>