Whats wrong with this code? (for GM ticket manager)

[GoogleCodeExporter]

Here is what i have so far for the gm ticket manager:

"./components/admin/admin.ticket.php"

<?php
$action = array();

$action = $CHDB->select("SELECT `ticket_id`, `guid`, `ticket_text` FROM
`character_ticket` ORDER BY `ticket_id` ");
$ticket = array();
if (count($action) > 0){
foreach ($action as $result1) {

    $ticket["id"] = $result1['ticket_id'];
    $ticket["player_name"] = $result1['guid'];
    $ticket["message"] = $result1['ticket_text'];
    }
}
unset($action, $result1);
?>

--------------------------------------------

and for "./templates/offlike/admin/admin.tickets.php"

<?php write_metalborder_header(); ?>
    <table cellpadding='3' cellspacing='0' width='100%'>
    <tbody>
       <tr> 
       <td class="rankingHeader" align='left' colspan='3'><?php echo 
$lang['post_pages'];?></td>
       </tr>
       <tr> 
      <td class="rankingHeader" align="center" colspan='3'
nowrap="nowrap"><?php echo $realm_info_new['name']; unset($realm_info_new)
?></td>          
    </tr>
    <tr>
      <td class="rankingHeader" align="center" nowrap="nowrap">#</td>
      <td class="rankingHeader" align="center" nowrap="nowrap"><?php echo
$lang['name'];?>&nbsp;</td>
      <td class="rankingHeader" align="center" nowrap="nowrap"><?php echo
$lang['message'];?>&nbsp;</td>
    </tr>
<?php foreach($ticket as $item): ?>
    <tr>
      <td class="serverStatus" align="center"><b style="color: rgb(102, 13,
2);"><?php echo $item['ticket_id']; ?></b></td>
      <td class="serverStatus"><a
href="armory/index.php?searchType=profile&character=<?php echo
$item['player_name']; ?>"><b style="color: rgb(35, 67, 3);"><center><?php
echo $item['guid']; ?></center></b></a></td>
      <td class="serverStatus" align="center"><b style="color: rgb(102, 13,
2);"><?php echo $item['ticket_text']; ?></b></td>
    </tr>
<?php endforeach; unset($ticket, $item); ?>
    </tbody>
    </table>
<?php write_metalborder_footer(); ?>
--------------------------------------

But this is what i get in the picture. I have 2 tickets that i made in game
but this is the result. what did i do wrong?

Original issue reported on code.google.com by wilson.steven10@gmail.com on 19 Feb 2010 at 3:23

Attachments:

• ticket.png

[GoogleCodeExporter]

nevermind, i got this ;p

Original comment by wilson.steven10@gmail.com on 19 Feb 2010 at 3:56

[GoogleCodeExporter]

Original comment by wilson.steven10@gmail.com on 19 Feb 2010 at 3:56

• Changed state: Fixed