Jump to content

How to display horizontally the values from a database


garaux

Recommended Posts

post-146690-0-68099000-1365771018_thumb.png


 

 

Hi there,

I am working on a simple application using PHP and MySql. The main table of the database is denominated article. A second table lang is related to the table article using a lookup.

 

I would like to display the values horizontally as shown in the file attached.

 

Here is the code I am using

 




include 'includes/db.inc.php'; 

try { 
     
  $query_sql = 'SELECT article_name, author_name, lang_name FROM article  
                INNER JOIN author 
                ON article.author_id = author.id 
        inner join lookuplang 
                on article.id = lookuplang.articleID                              
                inner join lang 
                on langID = lang.id 
        ORDER BY article.id ASC'; 
                
  
      $result = $GLOBALS['pdo']->query($query_sql); 
} 

foreach($result as $row) { 
    $valori[] = array('article_name'=>$row['article_name'],'author_name'=>$row['author_name'], 'lang_name'=>$row['lang_name']); 
} 
include 'test.html.php';



<?php foreach($valori as $lista):?> 
<?php 
$lingua = $lista['lang_name'] . ': Status'; 
?> 
<tr> 
<td> <?php echo $lista['article_name']?></td> 
<td> <?php echo $lista['lang_name']?></td> 

  
   
 </tr> 
<?php endforeach?></table> 

Could you please help me?

 

Thanks

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.