selecting data from database and display it in two columns

symoore22

this code can be seen here:
http://www.bestblanks.co.uk/incebayad.php

As you can see the list is in one column - how do you go about making this list display in 2 or 3 columns

thanks

simon

<html>

<?php include "vsadmin/db_conn_openebay.php";
$query = "SELECT * FROM products WHERE category='1' category='2' ORDER BY price";

$result = mysql_query($query) or die('Query failed: ' . mysql_error());
$num=mysql_num_rows($result);

mysql_close();

$i=0;
while ($i < $num) {

$name=mysql_result($result,$i,"name");
$price=mysql_result($result,$i,"price");
$image=mysql_result($result,$i,"image");
$description=mysql_result($result,$i,"description");
$category=mysql_result($result,$i,"category");
?>

<?
$i++;
}
?>
</html>

halojoy

<? php 
// some PHP and mySQL stuff
?>
<table width="100%" height="34" border="0" cellpadding="1" cellspacing="1">

  <tr>
<?php //////// These are 3 colums used right now ?>
  <td width="33%"><img src="http://www.bestblanks.co.uk/<?php echo "$image" ?> " alt="<?php echo "$name" ?>"></td>
  <td width="36%"><?php echo "$name" ?></td>
  <td width="31%">ï¿½<?php echo "$price" ?></td>
<?php //////// One extra column are 3 colums used right now ?>
  <td width="31%">mySQL is like lottery<br>
once in a while you can win!<br>
but 9 times out  of 10 you lose</td>
  </tr>

  </table>     

<? // this a counter, add +1 to get number of next item Row to Display
$i++;  } 
?>
</html>

I am from Barcelona, but some little I know ....