Table On Forumhome -- Filling it with PHP/SQL Data

[Masked Crusader]

Hey guys. After trying to make this work in the header of my site, I have given up. It is making for a ton of alignment and sizing issues.

What I want to do now is have the PHP code make a new table and place it on the ForumHome page in line with the actual forums. Here is a mockup of what I am talking about:



The new table needs to have a column span of 2 because I want to seperate the loot winner and the actual name of the loot.

Here is my current code. I am using this as a plugin at the moment.

PHP Code:

$link = mysql_connect('localhost', '****', '****') or die('Could not connect: ' . mysql_error());

mysql_select_db('****') or die('Could not select database');

$query = 'SELECT item_buyer, item_name FROM eqdkp_items ORDER BY raid_id DESC LIMIT 0,7';

$result = mysql_query($query) or die('Query failed: ' . mysql_error());

echo "<table width=400px align=right>";
echo "<tr><th colspan=1 align=center><b><u>Latest Loots</u></b></th></tr>";

while (list($buyer, $item_name) = mysql_fetch_row($result)) {

$item_link = "[item]".$item_name."[/item]";

$myMessage = itemstats_parse($item_link);

echo ("<tr><td align=right>".$myMessage." <b>".$buyer."</b></td></tr>");

}

echo "</table>";

mysql_free_result($result);

mysql_close($link); 


Any help would be appreciated.

Thanks.