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

controlling/creating accounts with privileges
hi all,
i'm trying to figure out how i can create/control account with privileges, for instance a

Warning: session_start() headers already sent error - Driving me Nuts!
I am trying my sister in laws site and I keep getting an error with my coding. I am more of a design

Change Web page language
i doing this thing first time but i dont find any suitable solution for it. On the demand of user. I

error with opendir
when i do this

if ($handle = opendir($dir)) {
while (false !== ($file = readdir($han

I have a parse error in this query help..
Code: $query1="INSERT INTO `rating` (`item_name`, `rating`, `ip_address`, `date_rated`) VALUES

curl javascript problem
Hi Experts.
I'm new curl and wanna to get some info from this http://www.amadeus.net/

when

Edit MySQL Row Using PHP and HTML Form
Hello,

Here's what I'm trying to do. Build a page where a user enters a MySQL row number in.

LIMIT $start, 10... how to pass last value queried into next page with GET??
Ok I know how to display the first or last 10 results of a query...

$result = mysql_query(&q

trouble printing an array....
I'm having some trouble printing out an array forwards. I'm figuring out the high and low of an arra

php form help
Hey,

I use a control file to set my meta tags and titles

Here's an example
Code: &a