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
20
Other forums
Simple email form - Newbie
Hello all,
First time poster!
I've been asked to create a simple HTML form that submit
Unable to retreve the values from Mysql Query
Hi,
Here is the php code that I have, Query is running properly in phpmyadmin and is resu
New Search Engine problem
Hey everyone,
I have a ZIP Code Radius search engine already functional. it displays all of t
Best way to read this text file.
Hi.I am planning to make a small application in C# to convert the players from Football manager 2010
[Need Help] php timing issues
I don't know what is going wrong. I need some help with being able to set an image at 9:00am Colorad
[PHP HELP] Php order form.
Hello to everyone @ phpfreaks. Im new to this site and hope to learn lots of things here.
Fir
Problem in String replace program's output
Hi all,
I was trying to make a program which accepts a string and replaces it with another stri
PHP Login
Hey!
I got this shopcart code online, am trying to modify it but am getting an error when i try a
Handling text changed in text box control using Ajax
I need to create a web form with a text box control. When someone types text into the textbox I nee
Join Query Help
Hi all,
I am having problems with the below code, which we shall call 'my first join query'!