'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_assoc($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_assoc($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 .= "

"; $table .= "Alias"; $table .= "	"; $table .= "Name		" . $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

Comic BookAppreciation

Character Database

Comic Book
Appreciation