GLO Posted February 5, 2014 Posted February 5, 2014 <?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. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.