Getting results to display across table properly

[micmac]

Hi all,
I have the following code:

<tr> 
  <td colspan="3" class="headingBlue"><br>
&nbsp;PRODUCTS</td>
</tr>
<tr> 
<?
include ("inc/db_conn_open.php");
$query = mysql_query("select * from t_home_prod_img,products
 WHERE t_home_prod_img.prod_thumbnail=products.prod_id 
ORDER BY t_home_prod_img.temp_home_id"); 
$total_rows = mysql_num_rows($query);
while ($row = mysql_fetch_array($query)) { 
$prod_id = $row["prod_id"];
$prod_num = $row["prod_num"];
$prod_img_small = $row["prod_img_small"];
$prod_num = stripslashes($row["prod_num"]);
?>
  <td><? echo $new_count ?><div align="center"><img src="prodimages/<? echo $prod_img_small ?>"></div></td>
</tr>
<?
}
?>

What will i need to do inorder to get the results to only display a maximum of 3 images across. If there are more results then they will get displayed below the top 3 images...and so on and so on.

Any ideas?

Cheers,
micmac

[tekky]

while($var=blahbleh)
{
     echo '<tr>';
     for($i=0;$i<3,$i++)
     {
          echo '<td>'.$row['var'].'</td>';
     }
     echo '</tr>';
}

play with that.... you can get it from there I hope 😉