I probably have this setup wrong well I know I do because nothing is showing up now. What I want is for it to show all the character names that are assigned to each user so yes than can be more than one. Can't figure out where at in my coding is my problem.
table efed_bio id charactername
table handler_characters id handler_id bio_id
table efed_handler id default_character_id login forum_id
Code: <?php { $query = "SELECT h.login, h.forumname, bio.charactername AS charactername FROM efed_bio AS bio, efed_handler_characters AS ech, efed_handler AS h WHERE h.default_char_id = bio.id AND ech.handler_id=h.id AND ech.bio_id=bio.id"; $result = mysql_query ( $query ); // Run The Query if ($result) { print '<h1 class=backstage>Active Handler Directory</h1><br />'; print '<table width="100%" class="table1">'; print '<tr class="rowheading">'; print '<td>Name</td>'; print '<td>Forum Name</td>'; print '<td>Characters</td>'; print '</tr>'; // Fetch and print all records. $i = 0; while ( $row = mysql_fetch_array ( $result, MYSQL_ASSOC ) ) { $sClass = 'row2'; if ($i ++ & 1) { $sClass = 'row1'; } printf ( "<tr class="%s">", $sClass ); printf ( "<td valign="top">%s</td>", $row [login] ); printf ( "<td valign="top">%s</td>", $row [forumname] ); printf ( "<td valign="top"><ul class="characters"><li>%s</li>", $row [charactername] ); print '</ul></td>'; print '</tr>'; } print '</table><br />'; print '<h2 class=backstage><form method=POST><input type=hidden name=action value=mainmenu><input type=submit value="Return to Main Menu" class=button200></form></h2>'; } } ?>
