Widget to Show uCash Leaders
 

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:

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!

I think you were close with the $output thing, you should just be able to replace each echo with "$output .=", like


You'll also need to change the part where you use ?> and <? around some html to be a string constant instead, and then assign it to $output the same way, like


If you had a lot of code you could also surround it with ob_start() and ob_end_clean() to buffer the output, but you only have a few lines so you might as well make the changes to assign to $output.

kh99 - thank you so much. I guess I was just using the output function wrong (I wasn't putting the period in front of it and I think I was messing up the apostrophes and semicolon), but your example helped and I think I've got it working now!

Again, this was my very first raw PHP/SQL code write. Through research I was able to write the code, but my understanding of what I'm writing is still a little fuzzy. Thanks again!