Need help with this php code

Posted: Tue Apr 18, 2006 4:37 am

I wanna use this php code in a block can someone put this php code in a block format for me?I want it to be seen on the right hand side of my site.

Code:

require('connect.php');
require('setting.php');

mysql_select_db("truebl_season",$db);

$mysql_query = "SELECT name as n, sum(points/gps) as ppg FROM fullstats GROUP BY n ORDER BY ppg DESC LIMIT 5";

$st = mysql_query($mysql_query, $db) or die(mysql_error());
$row_st = mysql_fetch_assoc($st);
$totalRows_st = mysql_num_rows($st);
?>

<div align="center">
<table width="169" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="red">
<tr bgcolor="black">
<td colspan="2" align="left"><div align="center">POINTS</div></td>
</tr>
<tr bgcolor="black">
<td width="68%" align="left" class="style1">Name</td>
<td width="32%" align="center">PPG</td>
</tr>
<?php do { ?>
<tr bgcolor="#FFFFFF">
<td align="left"><a href="<?PHP echo "http://truebl.hostingrapid.com/stats/player.php?name=".$row_st['n'].""; ?>"><?php echo $row_st['n']; ?></a></td>
<td align="center"><?php echo round($row_st['ppg'],1); ?> </td>
</tr>
<?php } while ($row_st = mysql_fetch_assoc($st)); ?>
<?php

mysql_select_db("lhfliv_season",$db);

$mysql_query = "SELECT name as n, sum(steal/gps) as spg FROM fullstats GROUP BY n ORDER BY spg DESC LIMIT 5";

$st = mysql_query($mysql_query, $db) or die(mysql_error());
$row_st = mysql_fetch_assoc($st);
$totalRows_st = mysql_num_rows($st);
?>

<div align="center">
<table width="169" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="red">
<tr bgcolor="black">
<td colspan="2" align="left"><div align="center">STEALS</div></td>
</tr>
<tr bgcolor="black">
<td width="68%" align="left" class="style1">Name</td>
<td width="32%" align="center">SPG</td>
</tr>
<?php do { ?>
<tr bgcolor="#FFFFFF">
<td align="left"><a href="<?PHP echo "http://truebl.hostingrapid.com/stats/player.php?name=".$row_st['n'].""; ?>"><?php echo $row_st['n']; ?></a></td>
<td align="center"><?php echo round($row_st['spg'],1); ?> </td>
</tr>
<?php } while ($row_st = mysql_fetch_assoc($st)); ?>
<?php

mysql_select_db("truebl_season",$db);

$mysql_query = "SELECT name as n, sum(rebounds/gps) as rpg FROM fullstats GROUP BY n ORDER BY rpg DESC LIMIT 5";

$st = mysql_query($mysql_query, $db) or die(mysql_error());
$row_st = mysql_fetch_assoc($st);
$totalRows_st = mysql_num_rows($st);
?>
<tr bgcolor="black">
<td colspan="2" align="left"><div align="center">REBOUNDS</div></td>
</tr>
<tr bgcolor="black">
<td width="68%" align="left" class="style1">Name</td>
<td width="32%" align="center">RPG</td>
</tr>
<?php do { ?>
<tr bgcolor="#FFFFFF">
<td align="left"><a href="<?PHP echo "http://truebl.hostingrapid.com/stats/player.php?name=".$row_st['n'].""; ?>"><?php echo $row_st['n']; ?></a></td>
<td align="center"><?php echo round($row_st['rpg'],1); ?> </td>
</tr>
<?php } while ($row_st = mysql_fetch_assoc($st)); ?>
<?php

mysql_select_db("truebl_season",$db);

$mysql_query = "SELECT name as n, sum(assist/gps) as apg FROM fullstats GROUP BY n ORDER BY apg DESC LIMIT 5";

$st = mysql_query($mysql_query, $db) or die(mysql_error());
$row_st = mysql_fetch_assoc($st);
$totalRows_st = mysql_num_rows($st);
?>
<tr bgcolor="black">
<td colspan="2" align="left"><div align="center">ASSISTS</div></td>
</tr>
<tr bgcolor="black">
<td width="68%" align="left" class="style1">Name</td>
<td width="32%" align="center">APG</td>
</tr>
<?php do { ?>
<tr bgcolor="#FFFFFF">
<td align="left"><a href="<?PHP echo "http://truebl.hostingrapid.com/player.php?name=".$row_st['n'].""; ?>"><?php echo $row_st['n']; ?></a></td>
<td align="center"><?php echo round($row_st['apg'],1); ?> </td>
</tr>
<?php } while ($row_st = mysql_fetch_assoc($st)); ?>
<?php

mysql_select_db("truebl_season",$db);

$mysql_query = "SELECT name as n, sum(block/gps) as bpg FROM fullstats GROUP BY n ORDER BY bpg DESC LIMIT 5";

$st = mysql_query($mysql_query, $db) or die(mysql_error());
$row_st = mysql_fetch_assoc($st);
$totalRows_st = mysql_num_rows($st);
?>
<tr bgcolor="black">
<td colspan="2" align="left"><div align="center">BLOCKS</div></td>
</tr>
<tr bgcolor="black">
<td width="68%" align="left" class="style1">Name</td>
<td width="32%" align="center">BPG</td>
</tr>
<?php do { ?>
<tr bgcolor="#FFFFFF">
<td align="left"><a href="<?PHP echo "http://truebl.hostingrapid.com/stats/player.php?name=".$row_st['n'].""; ?>"><?php echo $row_st['n']; ?></a></td>
<td align="center"><?php echo round($row_st['bpg'],1); ?> </td>
</tr>
<?php } while ($row_st = mysql_fetch_assoc($st)); ?>
</table>
 
<?php
$query_gp = "SELECT * FROM boxscore ORDER BY id DESC LIMIT 5 ";
$gp = mysql_query($query_gp, $db) or die(mysql_error());
$row_gp = mysql_fetch_assoc($gp);
$totalRows_gp = mysql_num_rows($gp);

?>


</div>
<table width="165" height="215" border="1" cellpadding="4" cellspacing="0" bordercolor="red">
<tr bgcolor="black">
<td colspan="2" align="left"><div align="center">RECENT
SCORES</div></td>
</tr>
<?php do { ?>
<tr>
<td width="93"><?PHP echo $row_gp['team']; ?> </td>
<td width="10"><center>
<?php echo $row_gp['score']; ?>
</center></td>
</tr>
<tr>
<td width="93"><?php echo $row_gp['opponent']; ?> </td>
<td width="10"><center>
<?php echo $row_gp['score1']; ?>
</center></td>
</tr>
<tr bgcolor="black">
<td colspan="2" align="left"> </td>
</tr>
<?php } while ($row_gp = mysql_fetch_assoc($gp)); ?>
</table>
 
 
 
 </td>

Posted: Tue Apr 18, 2006 4:28 pm

dang cant get no help lol