Block Content showing outside block

Worker Joined: Dec 03, 2005 Posts: 153

Hi all

I am created a block to show the top 10 players, I can get the information from the database to show, But, when I view the block the information is outside the block. Not too sure where I have gone wrong.

You can view it here:
http://www.camp-battlegroup.com/

Its towards the bottom.

Any advise

Scorp

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Please post a link to the source code.

Posted: Mon May 28, 2007 2:54 am

Hi Raven

Here is the code I have so far, How can I place the data results within the block under the headings?

Code:

<?php





if (eregi("block-toptenplayers.php",$PHP_SELF)) {


    Header("Location: index.php");


    die();


}





global $prefix, $db;


    


$result = $db->sql_query('SELECT playerID, kills, deaths FROM players ORDER BY kills DESC LIMIT 10');


  $content = '';


$content .= '<table><tr><td>Top 10 Players</td></tr></table>';





$content .= '<table><tr><td width="163">Players Name</td><td width="86">Kills</td><td width="82">Deaths</td><td width="86">Skill</td><td>Games</td></tr></table>';





// Place data under headings, this is the part I am not to sure of.





 echo "<table align=center>


   <tr>


  <td>Top 10 Players</td>


  </tr>





   <tr> 


        


    </tr>";





//fetch tha data from the database 


 while ($row = mysql_fetch_array($result)) { 


    echo " 


    <tr> 


        <td>" . $row['playerID'] . "</td>


        <td>" . $row[''] . "</td>


        <td>" . $row['kills'] . " </td>


                <td>" . $row[''] . "</td>


        <td>" . $row['deaths'] . "</td> 


    </tr>"; 


 }





echo "</table>";





?>

Cheers

Scorp

Posted: Mon May 28, 2007 8:07 am

All block content must be in the $content variable and the system will then echo $content. Instead of using echo you need to add the data to the $content variable.

Code:

// Place data under headings, this is the part I am not to sure of.





 $content .=  "<table align=center>


   <tr>


  <td>Top 10 Players</td>


  </tr>





   <tr>


       


    </tr>";





//fetch tha data from the database


 while ($row = mysql_fetch_array($result)) {


    $content .= "


    <tr>


        <td>" . $row['playerID'] . "</td>


        <td>" . $row[''] . "</td>


        <td>" . $row['kills'] . " </td>


                <td>" . $row[''] . "</td>


        <td>" . $row['deaths'] . "</td>


    </tr>";


 }





$content .= "</table>";

Posted: Mon May 28, 2007 12:11 pm

Cheers Raven

Works like a charm

Scorp