records side by side using table??

geoffcox

Hello,

have forgotten how to do following - any one can help?!

I want to display the records in a table 2 at a time across the page rather than 1 above the other as the following code does..

echo "<B>Your query found ".mysql_num_rows($result)." hit(s)</B><P><a href='shops.htm'><b>Another search?</b><p></a>";
echo "<TABLE BORDER='1' width=413 cellpadding='10'>\n";

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

  echo "<tr><td>";
  printf("<b>%s &nbsp;</b> <br> %s &nbsp; <br> %s &nbsp;<br> %s &nbsp;", $row["name"],$row["address"],$row["tel"],$row["type"]);
  echo "</td>";
  echo "</tr>";


  }
  echo "</TABLE>\n";
  }

How to do it?!

Cheers

Geoff

Anon

All you need to do Geoff is add another <td> and </td> in your while loop...

echo "Your query found ".mysql_num_rows($result)." hit(s)<P><a href='shops.htm'>Another search?<p></a>";
echo "<TABLE BORDER='1' width=413 cellpadding='10'>\n";

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

echo "<tr><td>";
printf("%s <br> %s <br> %s <br> %s ", $row["name"],$row["address"],$row["tel"],$row["type"]);
echo "</td>";

// this is the new code
echo "<td>\n";
// printf for second col goes here
echo "</td>/n";
// end of new code

echo "</tr>";

}
echo "</TABLE>\n";
}

kparker

You don't really want to read two rows each time through the loop. Instead, just read it as you are, and create a table cell as Gavin describes. At the end of the loop, if the number of rows returned was odd, add an extra empty cell to finish out the row.

geoffcox

Hi,

Have I missed something? If I use following I simpy get info duplicated!

Cheers
Geoff

echo "<tr><td>";
printf("%s <br> %s <br> %s <br> %s ", $row["name"],$row["address"],$row["tel"],$row["type"]);
echo "</td>";

// this is the new code
echo "<td>\n";
// printf for second col goes here
printf("%s <br> %s <br> %s <br> %s ", $row["name"],$row["address"],$row["tel"],$row["type"]);
echo "</td>\n";
// end of new code
echo "</tr>";
}
echo "</TABLE>\n";
}

Anon

I don't know what you want in each col, but the reason you are getting duplicate info is because you have the same printf in each cell.

echo "<tr><td>";
printf("%s <br> %s <br> %s <br> %s ", $row["name"],$row["address"]);
//I removed tel and type from here.
echo "</td>";

// this is the new code
echo "<td>\n";
// printf for second col goes here
printf("%s <br> %s <br> %s <br> %s ", $row["tel"],$row["type"]);
//I removed namw and address from here.
echo "</td>\n";
// end of new code
echo "</tr>";
}
echo "</TABLE>\n";
}

That same idea can be used to add as many columns to your table as you would like, just don't end the <tr> till the end of the loop.

Gav