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

remove a ; from emails in textarea
Code: <?php

session_start();

$database_host = "localhost&qu

Extending Exception to contain method name
I was wondering, if there's a way to extend Exception in such a way, that it would contain name of a

upload photo limits
ive got a upload photo script and im just trying to make more secure currently it limits size and as

EU VAT Package 2010
Does any one know whether SAP will be developing new reporting functionality due the new VAT rules t

Images in email problem
I found this script for sending emails, it works but if the email has <img src="image.jp

i have no idea why this isn't working
Code: <?php
session_start();
include("connect.php");

error_reporting(E

Adding post count
How would I make it so everytime someone clicks submit on my form, their row in the database for the

Get Total From While Loop
I'm trying to get the total for each product and add them for a Grand Total to list outside the loop

highlighting search terms
well, I started this in the regular PHP section, but it no longer fits there. Suffice it to say, I'm

mod_rewrite.c on windows ??
why it's not working on windows while it's working on other hosts???

this is the code i got