Display Single PHP Data in 2 Columns

Question

I would like to display a single data to 2 columns as mysql table result in my PHP file. I have tried with my code but the same data has been showed as result like <tr><td>result1</td><td>result1</td>.

I have tried with my code but with the following result:

| result 1 | result 1 |
| result 2 | result 2 |
| result 3 | result 3 |
| result 4 | result 4 |
| result 5 | result 5 |
| result 6 | result 6 |
| result ... | result ... |

But I need result as

| result 1 | result 2 |
| result 3 | result 4 |
| result 5 | result 6 |
| result 7 | result 8 |
| result ... | result ... |

Here is my code:

    <?php
        include('config.php');
        $data_content = '';
        $qry = "SELECT DISTINCT bankName FROM bankData ORDER BY bankName";
        $result = mysql_query($qry);
        while($row = mysql_fetch_array($result))
            {
                 $data_content.= "<a href='bank/".$row['bank_Name'].".php'> ".$row['bankName']."</a>";
            }
        mysql_close();
        ?>
<!DOCTYPE html>
<html lang="en">
<head>
<body>
<div>   
<table border="1">
    <?php
         for($i=0; $i<=1; $i++)
            {
            echo "<tr>";
            for($j=0; $j<=1; $j++)
            {
             echo "<td>";
             echo $data_content;
             echo "</td>"; 
            }
             echo "</tr>";
            }
    ?>
</table>
</div>
</body>
</html>

Help me please.

Your for loop isn't doing anything?

Devon Bessemer
– Devon Bessemer

2015-05-14 03:04:51 +00:00
Commented May 14, 2015 at 3:04 — Devon Bessemer
– Devon Bessemer, Commented May 14, 2015 at 3:04

Devon Bessemer · Accepted Answer · 2015-05-14 03:27:00Z

2

Put the loop down below:

<table border="1">
<?php
$i = 0;
while($row = mysql_fetch_array($result))
    {
         // Odd row opens
         if (++$i % 2 != 0) echo "<tr>";
         echo "<td><a href='bank/".$row['bankName'].".php'> ".$row['bankName']."</a></td>";
         // Even row closes
         if ($i % 2 == 0) echo "</tr>";  
    }
    // If you have an odd number of results, add a blank column and close the last row
    if ($i % 2 != 0)  echo "<td></td></tr>";
?>
</table>

(++$i % 2 != 0) increments $i and checks if it is odd. If it is odd, it will open the table row with </tr> and the next iteration will close a table row with </tr>.

edited May 14, 2015 at 3:27

answered May 14, 2015 at 3:15

Devon Bessemer

35.6k10 gold badges77 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dinesh DiNu Over a year ago

it works but had some issue. The first row's 2nd columns shows empty value.

Dinesh DiNu Over a year ago

Thanks for the code.. Now its perfectly works for me.. Added up-vote for your answer.. :-)

Collectives™ on Stack Overflow

Display Single PHP Data in 2 Columns

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related