Query issues

Posted on 16th Feb 2014 07:03 pm by admin

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>';
}
}
?>

Your Answer:

Login to answer

Other forums

Multiple Dropdown Selections
I have a form that let's a user insert a page with the ability to select categories. I want them to

Display a default image
I am trying to display generic image for items that don't have one, but I can't get it to display.

PHP not creating file.
Its supposed to create a .ini file in the /scriptfiles/users/ with the name they entered into the fi

Production of mango in processing industry
Hi,

We have one scenario ,company is in process industry,they are manufacturing MANGO pul

SOAP Issue
Hi,

I am facing some understanding problem with SOAP basic.kindly recommend some SOAP expert.

php unable to sent email
Hi, guys, I try to send a email through php but unfortunately the mail unable to sent. Here is my co

Array question
Does anyone know how to create a program that takes the $ amount for 8 different departments and gi

Word filter problem
Hello,

im trying to make a filter for words inputted in to my website but i want to store the

PHP5 - AJAX help
I've been following the tutorial on w2schools (http://www.w3schools.com/php/php_ajax_database.asp) a

JQuery, Masterpage, and Control issue
Hey everyone, I am using JQuery in several sites so I thought it would be best to place the library