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
Did you know?Explore Trending and Topic pages for more stories like this.
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>';
}
}
?>
No comments posted yet

Your Answer:

Login to answer
282 Like 20 Dislike
Previous forums Next forums
Other forums

mySQL and PHP search
Hello,
I am trying to code a project and ran into a brick wall with one of my pages. I am pretty

FPDF Help
I've been playing with the FPDF module. I was building a form and rolling right along and then sudde

How to display random record from table?
I have the following code:

Code: <?php
$display_block .= "<input type=

First root of a number
Hi,

I can't find any function in php to give me the first root of a number.
Is there any

Error Messaging not working
I changed the way my form tells the user of an error. But I can't seem to get it to work properly.

Help With editting and deleting form
Hallo !!

So look at this image :

http://img194.imageshack.us/img194/8272/snapshot5f.pn

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

how to put the 0-100 numbers into 1.txt and 100-200 into 2.txt ?
how to put the 0-100 numbers into 1.txt and 100-200 into 2.txt and so on 200-300 into file 3.txt ?

How to secure my login data to my database?
Hi there,

It may be a stupid question but I don't know how to secure my login data to my data

Pipe email to PHP - get mail adress from MySQL - send?
Hi all,

this is the challenge:

1) Our faculty at the college where I'm employed includ

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash