How to Display an Array Horizontally in A Set Number of Rows?

[Modernvox]

Hi Guys!

 

Trying to display data in 3 rows horizontally and 25 vertiacally

 

// Print out result
while($row = mysql_fetch_array($result)){
echo "There are ". $row['COUNT(biddersId)'] ." bidders logged.";
echo "<br />";
}



$query = "SELECT * FROM bidders ORDER BY biddersId"; 

$result = mysql_query($query) or die(mysql_error());

echo "<table border='1'>";
echo "<tr> <th>Bidders</th>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>"; 
        echo"<font face= \"calibri\" size=\"3\">";
echo $row['biddersId'];
echo "</br>";
        echo "</td><td>";
        

} 

echo "</table>";


?>

[wildteen88]

Multi-column results

[Modernvox]

Did I mention I Only been programming in PHP for a bout a year?

 

Where do I insert this Modulus Operator in my code?

 <?php
   $cols = 0;
   echo "<table><tr>";
   while ($cols < 20) {
      echo ($cols % 3 == 0)? "</tr><tr>" : "";
      echo "<td>$cols</td>";
      $cols++;
   }
   echo "</tr></table>";
?> 

[monkeytooth]

Where ever within the page you would like the results to display. All depends on the design of the page 

[Modernvox]

Where ever within the page you would like the results to display. All depends on the design of the page 

 

Understood, but what i meant was how do I tie the new code with my current code?

 

So where does this

 $cols = 0;
   echo "<table><tr>";
   while ($cols < 20) {
      echo ($cols % 3 == 0)? "</tr><tr>" : "";
      echo "<td>$cols</td>";
      $cols++;
   }
   echo "</tr></table>";

 

 

go to make this work...

 

 

 

 

 echo "<table border='1'>";
echo "<tr> <th>Bidders</th>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
   // Print out the contents of each row into a table
   echo "<tr><td>";
        echo"<font face= \"calibri\" size=\"3\">";
   echo $row['biddersId'];
   echo "</br>";
        echo "</td><td>";
       
   
}

echo "</table>";

[sasa]

try

<?php
// Print out result
while($row = mysql_fetch_array($result)){
echo "There are ". $row['COUNT(biddersId)'] ." bidders logged.";
echo "<br />";
}



$query = "SELECT * FROM bidders ORDER BY biddersId"; 

$result = mysql_query($query) or die(mysql_error());

echo "<table border='1'>";
echo "<tr>",  str_repeat("<td>Bidders</td>",3), "</tr>\n";
// keeps getting the next row until there are no more to get
$i=0;
while($row = mysql_fetch_array( $result )) {
        if ($i == 0) echo "<tr>";
        $i++;
// Print out the contents of each row into a table
echo "<td>"; 
        echo"<font face= \"calibri\" size=\"3\">";
echo $row['biddersId'];
echo "</font>";
        echo "</td>";
        if ($i == 3){
            echo "</tr>\n";
            $i=0;
        }

} 
if ($i>0){
    while ($i++ <3) echo '<td> </td>';
    echo "</tr>\n";
}
echo "</table>";

?>

[Modernvox]

try

<?php
// Print out result
while($row = mysql_fetch_array($result)){
echo "There are ". $row['COUNT(biddersId)'] ." bidders logged.";
echo "<br />";
}


Wow... Thanks. 
Works great! It's doing 9 rows down , but it works.

Thanks again!


$query = "SELECT * FROM bidders ORDER BY biddersId"; 

$result = mysql_query($query) or die(mysql_error());

echo "<table border='1'>";
echo "<tr>",  str_repeat("<td>Bidders</td>",3), "</tr>\n";
// keeps getting the next row until there are no more to get
$i=0;
while($row = mysql_fetch_array( $result )) {
        if ($i == 0) echo "<tr>";
        $i++;
// Print out the contents of each row into a table
echo "<td>"; 
        echo"<font face= \"calibri\" size=\"3\">";
echo $row['biddersId'];
echo "</font>";
        echo "</td>";
        if ($i == 3){
            echo "</tr>\n";
            $i=0;
        }

} 
if ($i>0){
    while ($i++ <3) echo '<td> </td>';
    echo "</tr>\n";
}
echo "</table>";

?>