[RESOLVED] help putting mysql data into html tables

jeramie78

Hello im trying to put mysql results into html tables for a hosting package type script but it is not working.

I need it to be like.

|--------------|---------------|------------|------------|
| package #| package1 |package2| package3|
|---------------|---------------|------------|------------|
| feature # | feature1 | feature1 | feature 1|
|---------------|---------------|-------------|------------|

and so forth
here is a link to what it is doing now
http://trebis.com/test.php

As you can see it is not displaying right

Here is my code

  $conn = db_connect();
  $result = $conn->query("select * from tblproducts where gid='2'");

  if (!$result) {
    return false;
  }
echo "<table><tr>";
for ($count=0; $row = $result->fetch_object(); $count++) {
$package = "<td>$row->name</td>";
$bandwidth = "<td>$row->configoption3</td>";

echo "$package";

echo "$bandwidth";



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

Weedpacket

You'll need to put the <tr> and </tr> inside the loop, so that there's a pair for each row.

jeramie78

ok i did as you mentioned but that isnt the effect im looking for you see where the packages are listed? i need them to be horizontal with the matching data underneath each one.

NogDog

I'd guess you'll probably have to build each row in separate strings, then output them once built, e.g.:

<table>
<?php
$row1 = $row2 = "<tr>";
while($row = $result->fetch_object())
{
   $row1 .= "<td>" . $row->name . "</td>";
   $row2 .= "<td>" . $row->configoption3 . "</td>";
}
echo $row1 . "</tr>\n";
echo $row2 . "</tr>\n";
?>
</table>

jeramie78

Thank you so much NogDog. Something so easy too. Have a great 09!!

Glad to hear your Noggin is doing well also 🙂

Weedpacket

Of course, the nice solution would involve pure CSS, but unfortunately, IE doesn't support the necessary parts of the standard (and note that the linked page is more than five years old).