Custom Table using SQL query and php

Question

I am trying to create a table from a sql query but I need to only have 3 results per table row.

I have a list of about 47 names so I have no problem printing them on a new line but how would I go about creating a table where the while loop would print a table row then print 3 table data cells with the query then create a new row for the next 3 values?

Exa:

Current While Loop:

while($row = mysql_fetch_assoc($result)) {

      echo "<tr>";  
      echo "<td><input type='checkbox'> ".$row['name']."</td>";
      echo "<td><input type='checkbox'> ".$row['name']."</td>";
      echo "<td><input type='checkbox'> ".$row['name']."</td>";
      echo "</tr>";


        }

Database Structure:

Thanks in advance!

have you considered using nested for/while loops as you iterate through your query result to display your table? It would be helpful if you could post more code/db structure and other things that you have tried so far. — Maximus2012
– Maximus2012, Commented Mar 25, 2014 at 20:44
I updated the post with while loop code and database structure. Thanks — 626
– 626, Commented Mar 25, 2014 at 20:53

ThreeLLMsInATrenchcoat · Accepted Answer · 2014-03-25 20:56:29Z

1

You can use the modulus operator (%) to check if you're ready for a new line.

    $number_of_names = count($names);
    $number_of_columns = 3; //you can change this at any point

    echo "<table><tr>";

    for($i=0;$ i<$number_of_names; $i++){
        echo "<td>" . $names[$i] . "</td>";

        if ($i % $number_of_columns == ($number_of_columns - 1) && $i<$number_of_names-1){
            echo "</tr><tr>";
        }
     }

     echo "</tr></table>";

edited Mar 25, 2014 at 20:56

answered Mar 25, 2014 at 20:51

ThreeLLMsInATrenchcoat

5193 silver badges9 bronze badges

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

Comments

Dragos Giurca · Accepted Answer · 2014-03-25 21:34:51Z

0

Try looping through the results using a for loop, then compare the remainder of dividing the iterator by 3, using the modulus operator.

echo "<tr>";
for($i = 0; $i<mysql_num_rows($result); $i++) {
  if($i%3==0) {
    echo "</tr><tr>";
  }
  $row = mysql_fetch_assoc($result)
  echo "<td><input type='checkbox'> ".$row['name']."</td>";
}
echo "</tr>";

answered Mar 25, 2014 at 21:34

Dragos Giurca

162 bronze badges

Collectives™ on Stack Overflow

Custom Table using SQL query and php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related