Displaying More Than One Item In A Row

tycragg

Hi guys, I'm displaying items from a database in PHP, but at the moment all of the items display one under the other... How can I make two items display in each row?? Here's my code:

$sql = mysql_query("SELECT * FROM merch");
if(!$sql) die("SQL ERROR: ".mysql_error());
while($row = mysql_fetch_array($sql)){
?>
  <br>
  <table width="318" height="207" align="center" cellpadding="5" bordercolor="#000000" BACKGROUND="Item.png">
  <tr>
    <td width="140" height="135" nowrap><img border="0" src='<?php echo($row['picurl']) ?>'></td>
    <td width="150" valign="top"><p><font size=4><b><u> <?php echo($row['description']);
?></u></b></font><br>
    </p>
      <p>Price: $<?echo ($row['price']);
?>
      <form target="paypal" action="https://www.paypal.com/cgi-bin/webscr" method="post">

  <div align="left">
    <input type="image" src="buy.jpg" border="0" name="submit">
    <input type="hidden" name="add" value="1">
    <input type="hidden" name="cmd" value="_cart">
    <b>
      <input type="hidden" name="business" value="***">
      </b>
    <input type="hidden" name="item_name" value="<?php echo($row['description']) ?>">
    <b>
      <input type="hidden" name="amount" value="<?php echo($row['price']) ?>">
      </b>
	  <input type="hidden" name="shipping" value="<?php echo($row['shipping']) ?>">
    <input type="hidden" name="currency_code" value="USD">
    <input type="hidden" name="bn" value="PP-ShopCartBF">
  </div>
</form></td>
  </tr>
</table>
<tr>
  <div align="center">
    <p align="right">
      <?php
}
?>

tycragg

Anyone know how to achieve this? Here's an example of what I'm getting at, where 3 items are displayed in each row:

http://www.houstoncallsmerch.com

liquorvicar

One way to do it would be to create an array of your DB results that matches the table layout you want, e.g.

$table = array();
$column = 0;
$row = 0;
 $sql = mysql_query("SELECT * FROM merch");
if(!$sql) die("SQL ERROR: ".mysql_error());
while($result = mysql_fetch_array($sql)){ 
    $table[$row][$column] = $result;
    $column++;
    if ($column>2) {
        $column = 0;
        $row++;
    }
}

You can then use foreach() to loop through your array and put the <TR> tags in the right places.