PHP/MySQL - Result on same line

[imdead]

Hello, i created this script for a client and have ran into an annoying error with the results displaying on a new line for each result instead of side by side, any help is welcome

 

Cheers

 

					  <?php
				  $subcat = mysql_real_escape_string(strip_tags(htmlspecialchars(protect($_GET['subcat']))));
				  $cat =  mysql_real_escape_string(strip_tags(htmlspecialchars(protect($_GET['cat']))));
$sql = @mysql_query("SELECT * FROM cakes WHERE category =\"$cat\" AND sub_cat=\"$subcat\" ORDER BY id DESC");
while ($row = mysql_fetch_array($sql)) {
$reference = $row['reference'];
$image = $row['image'];
echo ("<p><img src='./images/cakes/$image' height='289px' width='177px' alt='IMAGE OF CAKE'></img><br />");
echo ("<b>Reference:</b>$reference"."</p>");
}
if (!$reference) {
echo 'There are no cakes in this category yet.';
}
?>

 

I know the errors only going to be something small i'm missing, but i've been coding all day

[blacknight]

<br /> = new line

[imdead]

That br is for the text, not for the next image

[blacknight]

try taking out your <p> tages same idea makes paragraphs under each other

[imdead]

I've tried taking the <P> tags out, and this was the result

[blacknight]

ever think of using a table?

$html = '<table><tr>';
$cols = 3;// can be any size you want
$x = 0;
while ($row = mysql_fetch_array($sql)) 
{
$x++;
$reference = $row['reference'];
$image = $row['image'];
$html .= '<td>';
$html .= '<p><img src="./images/cakes/'.$image.'" height="289px" width="177px" alt="IMAGE OF CAKE"></img><br />';
$html .= '<b>Reference:</b>'.$reference.'.</p>';
$html .= '</td>';
if ($x == $cols)
{
	$html .= '</tr><tr>';
	$x=0;
}
}

if (!$reference) 
{
$html .= '<td>There are no cakes in this category yet.</td>';
}
echo $html;

[imdead]

aha with some slight changes thats got it thankyou very much, with the cols though depending on how many it needs, should i use a count first and then use the result as the var?

[blacknight]

no i would set this for page width it sets how many colums you have going across the page 3-5 is usualy good depending on the size of the page