PHP / HTML table issue

[Mainer82]

I'm having a hard time with displaying data from my database in a three cell table layout.

Here's what I'm using right now for code:

      while ($row = mysql_fetch_array($result)) {
      echo '
      <table class="cells">
         <tr>
              <td style="width: 162px;">
                 <img src="' . $row['m_img'] . '" alt="' . $row['m_title'] . '" />
                 <br />
                 <a href="' . $row['m_url'] .'">' . $row['m_title'] . '</a>
              </td>
         </tr>
      </table> 

What happens is that each item and image is displayed as one row in a table. Any suggestions?

[Ize]

echo '<table class="cells">';
while ($row = mysql_fetch_array($result)) {
      echo '
         <tr>
              <td style="width: 162px;">
                 <img src="' . $row['m_img'] . '" alt="' . $row['m_title'] . '" />
                 <br />
                 <a href="' . $row['m_url'] .'">' . $row['m_title'] . '</a>
              </td>
         </tr>';
}
echo '</table>'; 

You are outputting the <table> tag in the loop, which means it gets outputted for every row in your result set, which means every row gets its own table.

[Mainer82]

Ah, yes of course. Now, the only problem is that each <td> is under one another, what I'd like is this (and I've been trying different selections:

----------
|td|td|td|
|td|td|td|
|td|td|td|
----------

I'm stumped.

[simplecode]

wht kinda o/p u want

[Mainer82]

Just like I posted above, just like this:
----------
|td|td|td|
|td|td|td|
|td|td|td|
----------

Right now this is the output:
|td|
|td|
|td|

[simplecode]

<table width="100%" border="1" cellspacing="0" cellpadding="0">
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table>

use such table structur in ur loop

[Mainer82]

I don't see how that's possible with this code:

echo '<table class="cells">';
      while ($row = mysql_fetch_array($result)) {
      echo '
         <tr>
              <td style="width: 162px;">
                 <img src="' . $row['m_img'] . '" alt="' . $row['m_title'] . '" />
                 <br />
                 <a href="' . $row['m_url'] .'">' . $row['m_title'] . '</a>
              </td>
         </tr>';
   }
   echo '</table>'; 

I know how to make a table, just not using PHP data.

[simplecode]

echo '<table class="cells">';
while ($row = mysql_fetch_array($result)) {
      echo '<tr>
                <td><img src="' . $row['m_img'] . '" alt="' . $row['m_title'] . '" /></td>
                <td> Somethin here </td>
                <td><a href="' . $row['m_url'] .'">' . $row['m_title'] . '</a></td>
              </tr>';
            
}
echo '</table>'; 

is this wht u want

[Ize]

Play around with the modulo operator:

<?php
    $max     = 10;
    $i        = 1;
    while ($i<$max)
    {
        if ($i &#37; 3 == 0) print $i . "<br>";
        $i++;
    }
?>

Output:

3
6
9 

This bit... "$i % 3 == 0" tells PHP to do something everytime $i is dividable by 3. Use this to end and start your rows.

Hope this helps

[clamcrusher]

im cutting and pasting some code, you will need to adapt it.

// how many columns we want our table to have
$columns = 3;



echo "<table>\n";

for ($i = 0; $row = mysql_fetch_assoc($result); $i++) {

    if (($i % $columns) == 0) {
        echo " <tr>\n";
    }

    echo "  <td>" . $row['fieldname'] . "</td>\n";

    if (($i % $columns) == ($columns - 1)) {
        echo " </tr>\n";
    }

}

// find out how many empty <td></td> we need to output now
// to make the html correct and well formed
$remainder = ($columns - ($i % $columns)) % $columns;

// do we have remainders?
if ($remainder > 0) {
    echo str_repeat("  <td></td>\n", $remainder);
    // or alternatively
    // echo "  <td colspan=\"$remainder\"></td>\n";
    echo " </tr>\n";
}
echo "</table>\n"; 

you could also do similar with array_chunk() and array_pad()

[Mainer82]

Here's what i'm using:

// how many columns we want our table to have
      $columns = 3;
      echo "<table>\n";
      for ($i = 0; $row = mysql_fetch_assoc($result); $i++) {
      if (($i &#37; $columns) == 0) {
        echo " <tr>\n";
       }

        echo "  <td>"<img src=\"' . $row['m_img'] . ' \" alt=\"' . $row['m_title'] . '\" />"</td>\n";

      if (($i % $columns) == ($columns - 1)) {
        echo " </tr>\n";
       }

      }

      // find out how many empty <td></td> we need to output now
      // to make the html correct and well formed
      $remainder = ($columns - ($i % $columns)) % $columns;

      // do we have remainders?
      if ($remainder > 0) {
       echo str_repeat("  <td></td>\n", $remainder);

       // or alternatively
       // echo "  <td colspan=\"$remainder\"></td>\n";
       echo " </tr>\n";
      }
      echo "</table>\n"; 

and I get this:
Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/ogden2k/public_html/ogden2k/iedb/movies/gallery.php on line 36

Same thing if I take the \ out before the "

[Procode]

What exactly is line 36?

[Mainer82]

echo " <td>"<img src="' . $row['m_img'] . ' \" alt=\"' . $row['m_title'] . '\" />"</td>n";

[Mainer82]

Any suggestions?

[Mainer82]

I got it to work... the problem was the " vs the '.

[Mainer82]

I got it to work... the problem was the " vs the '.

[simplecode]

try this

<? echo " <td><img src='".$row['m_img']."' alt='".$row['m_title']."' /></td>n"; ?>