'alias ASC', 2 => 'name ASC', 3 => 'align ASC, alias ASC' ); $conn = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS) or die('Could not connect to MySQL database. ' . mysql_error()); mysql_select_db(SQL_DB, $conn); $sql = "SELECT c.id, p.power " . "FROM char_main c " . "JOIN char_power p " . "JOIN char_power_link pk " . "ON c.id = pk.char_id AND p.id = pk.power_id"; $result = mysql_query($sql) or die(mysql_error()); if (mysql_num_rows($result) > 0) { while ($row = mysql_fetch_array($result)) { $p[$row['id']][] = $row['power']; } foreach ($p as $key => $value) { $powers[$key] = implode(", ", $value); } } $sql = "SELECT c.id, n.alias " . "FROM char_main c " . "JOIN char_good_bad_link gb " . "JOIN char_main n " . "ON (c.id = gb.good_id AND n.id = gb.bad_id) " . "OR (n.id = gb.good_id AND c.id = gb.bad_id)"; $result = mysql_query($sql) or die(mysql_error()); if (mysql_num_rows($result) > 0) { while ($row = mysql_fetch_array($result)) { $e[$row['id']][] = $row['alias']; } foreach ($e as $key => $value) { $enemies[$key] = implode(", ", $value); } } $table = "
No characters " . "currently exist.
"; ?> Comic Book Appreciation

Comic Book
Appreciation


Character Database

0) { $table = ""; $table .= ""; $table .= ""; // build each table row $bg = ''; while ($row = mysql_fetch_array($result)) { $bg = ($bg=='F2F2FF'?'E2E2F2':'F2F2FF'); $pow = ($powers[$row['id']]==''?'none':$powers[$row['id']]); if (!isset($enemies) || ($enemies[$row['id']]=='')) { $ene = 'none'; } else { $ene = $enemies[$row['id']]; } $table .= "" . "" . ""; } $table .= "
"; $table .= "Alias"; $table .= ""; $table .= "NameAlignmentPowersEnemies
" . $row['alias']. "" . $row['name'] . "" . $row['align'] . "" . $pow . "" . $ene . "
"; $table = str_replace('evil', 'evil', $table); $table = str_replace('good', 'good', $table); } echo $table; ?>
New Character • Edit Powers