Display 3 items across page page

[adrianuk29]

I am improving on a shopping cart script that I found in an example. I would like your ideas or thoughts on how I would display 3 products in a line (horizontally) as apposed to one after another on the page. I have seen this done on oscommerce AND other carts. Here is the script.

<?php
include("db.php");

// Get a connection to the database

$cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);

$result = mysql_query("select * from products ORDER by product_name asc");

while($row = mysql_fetch_array($result)) { ?>

< HTML CODE AND PHP TO DISPLAY PRODUCTS>

<?php
}
?>

Thank you for your help.

[thoand]

$result = mysql_query("select * from products ORDER by product_name asc LIMIT 3"); 
while($row = mysql_fetch_array($result)) { ?> 

<?
echo $row['product_name']. ", ";
?>

<?php 
} 

output:

Product1, Product2, Product3

Your could do this nicer with some CSS and tables etc.

Thomas