Request: Olympiad Script

[GLO]

<?php

$sql = mysql_query("SELECT * FROM olympiad_nobles ORDER BY char_id") or die(mysql_error());

$cor = 0;

while($c = mysql_fetch_array($sql)) {

      $cor = $cor + 1;

      $bg  = $cor % 2 == 0 ? '#F1F1F1' : '#E8E8E8';

 

      $h = mysql_query("SELECT * FROM characters WHERE obj_Id = '".$c['obj_Id']."'") or die(mysql_error());

      $n = mysql_fetch_array($h);

      $l = mysql_query("SELECT * FROM characters WHERE base_class = '".$n['base_class']."'") or die(mysql_error());

      $g = mysql_fetch_array($l);

      $i = mysql_query("SELECT * FROM clan_data WHERE clan_id = '".$n['clanid']."'") or die(mysql_error());

      $j = mysql_fetch_array($i);

      $k = mysql_query("SELECT * FROM olympiad_nobles ") or die(mysql_error());

      $w = mysql_fetch_array($k);

      $g['class_id'] = explode("_", $g['class_id']);

      $j['clan_name'] = empty($n['clanid']) ? 'No Clan.' : $j['clan_name'];

      $j['ally_name'] = empty($j['ally_id']) ? 'No alliance.' : $j['ally_name'];

 

?>

 

  <tr class="style8" align="center" height="23">

    <td><?php echo $n['char_name']; ?></td>

    <td><?php echo ucwords($g['class_name'][1]); ?></td>

    <td><?php echo $w['olympiad_points']; ?></td>

    <td><?php echo $w['competitions_done']; ?></td>

    <td><?php echo $j['clan_name']; ?></td>

    <td><?php echo $j['ally_name']; ?></td>

 

 

  </tr>

<?php

 

I got this on my php but seems it doesn't show it correctly...

I think something is wrong on tables...

 

Thx if anyone try to fix it.