[RESOLVED] Display DB Results Per Table Row

[obrienkev]

Hi all,

I want to display a cretain number of results per row in a table.

e.g. I want to display 5 results per row - id 1-5 will be in row1; id 6-10 row2, etc..

How do I fix my code below to do this? Thanks.

if($num_results > 0)
{

   echo '<table><tr>';

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

    for($i=0; $i<5; $i++)
   {
        echo '<td>';
		    echo '<a href="index.php?id='.$row['id'].'">'.$row['name'].'</a>';
		    echo '</td>';
	  } // end for


 } // end while

   echo '</tr></table>';	

} // end if

[moracom]

Try this

<?php
//set the number of columns
$columns = 2;

mysql_connect('localhost','','');
mysql_select_db('test');
$query = "SELECT stuff FROM mystuff ORDER BY stuff";
$result = mysql_query($query);

//we add this line because we need to know the number of rows
$num_rows = mysql_num_rows($result);
echo "<TABLE BORDER=\"0\">\n";

//changed this to a for loop so we can use the number of rows
for($i = 0; $i < $num_rows; $i++) {
    $row = mysql_fetch_array($result);
    if($i % $columns == 0) {
        //if there is no remainder, we want to start a new row
        echo "<TR>\n";
    }
    echo "<TD>" . $row['stuff'] . "</TD>\n";
    if(($i % $columns) == ($columns - 1) || ($i + 1) == $num_rows) {
        //if there is a remainder of 1, end the row
        //or if there is nothing left in our result set, end the row
        echo "</TR>\n";
    }
}
echo "</TABLE>\n";
?>