printing a table with php and sql values

Question

I need to print several rows and within each row several tds... After 3 tds it should add a tr but I am not sure how to approach this.

echo '<table>';
  for($counter=0; $counter <= $row2 = mysql_num_rows($result2);counter++) {
    print("<tr>");

    while($row2 = mysql_fetch_array( $result2 )) { 
      $_name = $row2["_name"];
      $_image = $row2["_image"];

      print("<td valign='top' width='230px' height='148px'>");
      print("<p class='p_imageStyle'>$_name</p>");
      print("<img class='custom' alt='' src='$_image' />");
      print("</td>");
    }

    print("</tr>");
  }

  echo '</table> ';

someone posted an answer and it worked.. please repost so that i can give acknowledge your response... The only thing it was missing to increment the counter. — user710502
– user710502, Commented Nov 13, 2011 at 23:25

Dev Jadeja · Accepted Answer · 2011-11-14 00:28:36Z

2

  echo '<table>';
  $counter=1;
  while($row2 = mysql_fetch_array( $result2 )) { 
  if($counter%3==1)
  print("<tr>");
  $_name = $row2["_name"];
  $_image = $row2["_image"];

  print("<td valign='top' width='230px' height='148px'>");
  print("<p class='p_imageStyle'>$_name</p>");
  print("<img class='custom' alt='' src='$_image' />");
  print("</td>");
  if($counter%3==0)
  print("</tr>");
  $counter++;
}
$counter--;
$rem=3-$counter%3; //modifed as per alartur 
for($i=0;$i<$rem;$i++)
{
  echo "<td></td> //print remaining td
}
if($rem!=0)
echo "</tr>";   //close tr if not closed
echo '</table> ';

edited Nov 14, 2011 at 0:28

answered Nov 13, 2011 at 23:45

Dev Jadeja

1302 silver badges10 bronze badges

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

1 Comment

alexpirine Over a year ago

The number of remaining tds is wrong (you should rather count up to (3-rem) if rem != 0), but seems ok for the rest.

Collectives™ on Stack Overflow

printing a table with php and sql values

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related