[RESOLVED] multiple rows and colums

[benracer]

hi,
how can i make results from a query be displayed in say 5 columns and x amount of rows without returning the same results.

At the moment if the limit is set to 25 all results are on one row. how do i go about setting a max columns to 5 then creating another row for 5 and so on until there are no results remaining?

<?php
$sql="SELECT * from items WHERE id>50 ORDER BY rand() LIMIT 5";
$result=mysql_query($sql);
?>
              <table width="95%" border="0" cellpadding="3" cellspacing="3" style="padding-top:5px">
                <tr>
                  <td align="center" valign="top">
<?
while($rows=mysql_fetch_array($result)){
?>
                    <table border="0" align="center" >
                      <tr>
                        <td align="center"><a href="item.php?id=<? echo $rows['id']; ?>" target="_self"><img src="<? echo $rows['image']; ?>" alt="<? 
echo "#";
echo $rows['code']; 
echo " - ";
echo $rows['name']; 
?>" border="0" class="mediumimage"/></a></td>
                      </tr>
                      <tr>
                        <td align="center" valign="middle"><a href="item.php?id=<? echo $rows['id']; ?>" class="style22">#<? echo $rows['code']; ?> - <? echo $rows['name']; ?></a></td>
                      </tr>
                      <tr>
                        <td align="center" valign="middle"><a href="item.php?id=<? echo $rows['id']; ?>" class="style22">&pound;<? echo $rows['price']; ?></a></td>
                      </tr>
                  </table></td>
                  <td>
<?
}
?></td>
                </tr>
              </table>

like on ebay here
http://electronics.search.ebay.co.uk/ipod_MP3-Players_W0QQfclZ4QQfsooZ2QQfsopZ32QQsacatZ73839

but this is with 2 columns

[bpat1434]

You'd have to have a "counter" inside your while loop. WHen that counter's value is 5, create a new row.

Something like:

$i = 1;
while($row = mysql_fetch_array($result))
{
    if($i % 5 == 0) // If $i / 5 has no remainder (meaning it's 5, 10, 15, 20, etc.)
    {
        echo '</tr>
    <tr>';
    }
}

How that would fit into your code is that you'd have to make each looped item it's own <td> element (instead of just a set of tables). So for example:

<?php
$sql="SELECT * from items WHERE id>50 ORDER BY rand() LIMIT 5";
$result=mysql_query($sql);
?>
              <table width="95%" border="0" cellpadding="3" cellspacing="3" style="padding-top:5px">
                <tr>
<?php
$i=1;
while($rows=mysql_fetch_array($result)){
    if($i % 5 == 0)
    {
    ?>
                 </tr>
                 <tr>
    <?php
    }
?>
                  <td align="center" valign="top">
                    <table border="0" align="center" >
                      <tr>
                        <td align="center"><a href="item.php?id=<? echo $rows['id']; ?>" target="_self"><img src="<? echo $rows['image']; ?>" alt="<?
echo "#";
echo $rows['code'];
echo " - ";
echo $rows['name'];
?>" border="0" class="mediumimage"/></a></td>
                      </tr>
                      <tr>
                        <td align="center" valign="middle"><a href="item.php?id=<? echo $rows['id']; ?>" class="style22">#<? echo $rows['code']; ?> - <? echo $rows['name']; ?></a></td>
                      </tr>
                      <tr>
                        <td align="center" valign="middle"><a href="item.php?id=<? echo $rows['id']; ?>" class="style22">&pound;<? echo $rows['price']; ?></a></td>
                      </tr>
                    </table>
                  <td>
<?php
}
?>
                </tr>
              </table>

Hope that helps you out.

[benracer]

Sorted - Thanks

<?php 
$sql="SELECT * from items WHERE id>50 ORDER BY rand() LIMIT 15"; 
$result=mysql_query($sql); 
?> 
              <table width="95%" border="0" cellpadding="3" cellspacing="3" style="padding-top:5px"> 
                <tr> 
<?php 
$i=21; 
while($rows=mysql_fetch_array($result)){ 
$i = $i - 1;
    if($i % 5 == 0) 
    { 
    ?> 
                 </tr> 
                 <tr> 
    <?php 
    } 
?> 
                  <td align="center" valign="top"> 
                    <table border="0" align="center" > 
                      <tr> 
                        <td align="center"><a href="item.php?id=<? echo $rows['id']; ?>" target="_self"><img src="<? echo $rows['image']; ?>" alt="<? 
echo "#"; 
echo $rows['code']; 
echo " - "; 
echo $rows['name']; 
?>" border="0" class="mediumimage"/></a></td> 
                      </tr> 
                      <tr> 
                        <td align="center" valign="middle"><a href="item.php?id=<? echo $rows['id']; ?>" class="style22">#<? echo $rows['code']; ?> - <? echo $rows['name']; ?></a></td> 
                      </tr> 
                      <tr> 
                        <td align="center" valign="middle"><a href="item.php?id=<? echo $rows['id']; ?>" class="style22">&pound;<? echo $rows['price']; ?></a></td> 
                      </tr> 
                    </table> 
                  <td> 
<?php 
} 
?> 
                </tr> 
              </table>