Manipulating MySQL Results with HTML Table using PHP

Question

I am hoping someone can help me. I am creating a hardware web page that - In the content section will display the main categories which are read from the database. I want the results to be read as 3 per row and 2 columns as there are 6 categories. Similar to what i have below.

| CAT1 | CAT2 | CAT3 |
| CAT4 | CAT5 | CAT6 |

I currently have it displaying in columns but it is just duplicating the same data in all the columns. i.e.

| CAT1 | CAT1 | CAT1 |
| CAT2 | CAT2 | CAT2 |

Let me know if anyone has any ideas.

Here is the code I am using:

$query = "SELECT distinct category FROM listings";
$result = mysql_query($query);

echo "<table>";

while($row = mysql_fetch_array($result)){
echo "<tr><td>" . $row['category'] . "</td><td>" . $row['category'] . "</td></tr>";
}

echo "</table>";

Neeraj Kumar · Accepted Answer · 2015-01-15 11:45:42Z

2

This work for all categories as long as you want.

$catNo = 1;

echo "<table> <tr>";

while($row = mysql_fetch_array($result)){
    echo "<td>" . $row['category'] . "</td>";
    if ($catNo % 3 == 0) {
       echo "</tr><tr>"
    }
    $catNo++;
}

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

answered Jan 15, 2015 at 11:45

Neeraj Kumar

1,0681 gold badge9 silver badges22 bronze badges

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

Comments

Daniel Stanley · Accepted Answer · 2015-01-15 11:43:03Z

2

The issue is with your while statement using the same row for each <td>, you could use a counter to check when to put a new row:

$catNo = 1;

echo "<table> <tr>";

while($row = mysql_fetch_array($result)) {
    echo "<td>" . $row['category'] . "</td>";
    $catNo++;
    if ($catNo == 3) {
        echo "</tr><tr>"
        //if you end up having more than six categories reset $catNo
        $catNo = 1;
    }

}

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

answered Jan 15, 2015 at 11:43

Daniel Stanley

1,0506 silver badges15 bronze badges

Comments

gmiley · Accepted Answer · 2015-01-15 11:44:39Z

2

The problem you are running into is that you are printing the same value in each column because $row is not being moved to the next iteration. Given your output from your query you could do the following:

echo "<table><tr>";
$idx = 0;
while($row = mysql_fetch_array($result)) {
   if(++$idx % 3 == 0) {
      echo "</tr><tr>";
   }
   echo "<td>" . $row['category'] . "</td>";
}
echo "</tr></table>";

The % operator is a modulo operator and returns the remainder of the operator divided by the operand. In this case $idx divided by 3, so after 3 rows "</tr><tr>" is echoed, then it is all closed after the loop is finished.

answered Jan 15, 2015 at 11:44

gmiley

6,6041 gold badge15 silver badges25 bronze badges

Collectives™ on Stack Overflow

Manipulating MySQL Results with HTML Table using PHP

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related