[ZacFields]

Hi All,

I've written some code (my first ever SQL/PHP code write, actually) that simply takes each users' Ucash balance and displays them in descending order, stopping at the 20th ranked person.

Running this code directly from a PHP file on my site works great, but I'm trying to get it into a CMS widget and I'm having a little trouble with the concept of using the $output variable rather than echo. Obviously just changing every instance of "echo" to "$output" doesn't work, what am I doing wrong? Here is the code raw:

$user=$_POST['user'];
$username=$_POST['username'];
$ucash=$_POST['ucash'];



$query = "SELECT * FROM `user` ORDER BY `user`.`ucash` DESC";
$result=mysql_query($query);
$num="20";


mysql_close();


echo "<b>Vcash Leaderboard</center></b><br><br>";
?>
<table border=0>
<tr><td><b>Username</b></td><td><b>vCash</b></td></tr>
<?
$i=0;
while ($i < $num) {


$rank=$i+1;

$username=mysql_result($result,$i,"username");
$ucash=mysql_result($result,$i,"ucash");
?>


<tr><td><?echo "$rank. $username"; ?> </td>
<td>$<?echo ROUND("$ucash"); ?> </td> </tr>




<?
$i++;
}


echo "</table>";

I'm feeling like it's something very basic that I'm missing. I'm proud of myself for doing the research that allowed me to write the code in the first place, but this $output stuff has thrown a curveball at me and I guess I'm not just understanding the concept.

Does anyone have any pointers on what I need to change in this code to make it work in the php direct execution widget? Essentially, when I paste this code in exactly as it is, it runs the script just fine... but it displays at the top of the page above the header.

--------------- Added [DATE]1323475015[/DATE] at [TIME]1323475015[/TIME] ---------------

Whoops, can somebody move this to the VB4 programming section? My apologies!