Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?
  1. Home
  2. Discussion Forum
  3. PHPFusion 9 Support
  4. Modifications and Requests - 9
  5. Inner join???

Inner join???

Asked Modified Viewed 1,229 times
Back to Forum Index Previous Topic Next Topic
Print
C
Catzenjaeger
C
  • Senior Member, joined since
  • Contributed 408 posts on the community forums.
  • Started 137 threads in the forums
  • Started this discussions
asked
Senior Member

i have this... and this shows all manufacturers where stored in my figure database.
But i want to show only the manufacturer from my selected figure in my figure.php .
Testsite: http://aliencollectors.com/site/infus...igure_id=1

on this site i have tables where i show data about the figure from different tables. But i see only the datas from DB_FIGURE.
All where you see "numbers" is wrong

Code Download source
$result = dbquery("SELECT *   FROM ".DB_FIGURE_MANUFACTURERS."");

   if (dbrows($result)) {
      while ($data = dbarray($result)) {
         echo "<b>".$data['figure_manufacturer_name']."</b>\n";
      }
} else {
   echo "<div style='text-align:center'>nothing found</div>\n";
}


The title and id from the figur is in the Database DB_FIGURE stored.

DB_FIGURE
figure_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
figure_title varchar(200) NOT NULL DEFAULT '',

I have try it with some inner joins and other but i get only show all manufacturers and not this from my figure.

in attachment my php file what shows my figures
can anyone help? thanx

here is a part of my table where i get the datas and show them. But i see only the ID not the text
Code Download source

         echo "<table class='tbl-border' width='100%'>\n";         
         echo "<tr>";   
         //echo "<colgroup><col width='1*'><col width='2*'><col width='1*'><col width='2*'></colgroup>\n";
         echo "<colgroup><col width='20%'><col width='30%'><col width='20%'><col width='30%'></colgroup>\n";         
               echo "<td style='word-break:break-all;word-wrap:break-word' class='tbl2'><b>".$locale['figure_417'].":</b></td>\n";
               echo "<td style='word-break:break-all;word-wrap:break-word' class='tbl3'>".($datamanufacturer['figure_manufacturer'] ? $datamanufacturer['figure_manufacturer'] : "-")."</td>\n";
               echo "<td style='word-break:break-all;word-wrap:break-word' class='tbl2'><b>".$locale['figure_443'].":</b></td>\n";
               echo "<td style='word-break:break-all;word-wrap:break-word' class='tbl3'>".($data['figure_weight'] ? $data['figure_weight'] : "-")."</td>\n";      
         echo "<tr>";   
Edited by Catzenjaeger on 09-05-2016 01:41,
Catzenjaeger attached the following file:
figure.zip [No information available / 171 Downloads]
0 replies

1 post

S
SGT-TURKEY
S
.:: We have success the difficult, impossible that is just takes time ::.
  • Junior Member, joined since
  • Contributed 16 posts on the community forums.
  • Started 8 threads in the forums
answered
Junior Member

you can see inner join method at administration/news.php file.

for example:

SELECT m.*, t.* FROM manifacturers m
INNER JOIN anothertable t ON t.fieldname=m.fieldname
WHERE
ORDER BY
LIMIT parameters....

and you can use an another joint methods.. LET JOIN, INNER JOIN, RIGHT JOIN

regards...
0 replies

Category Forum

Modifications and Requests - 9

Labels

None yet

Statistics

  • Views 0 views
  • Posts 1 post
  • Votes 0 votes
  • Topic users 2 members

2 participants

C
C
  • Senior Member, joined since
  • Contributed 408 posts on the community forums.
  • Started 137 threads in the forums
  • Started this discussions
S
S
.:: We have success the difficult, impossible that is just takes time ::.
  • Junior Member, joined since
  • Contributed 16 posts on the community forums.
  • Started 8 threads in the forums

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet