table

[kapseli]

How i can print like this
<table>
<tr>
<td>product1<7td> <td> product2</td> <td>product3</td>
<tr>

<tr>
<td>product4<7td> <td> product5</td> <td>product6</td>
<tr>
</table>

How I have to modify this?

<?php
$result = mysql_query ("select * from kuvasto where table_categoria = 'miesten_casual'");
$num = mysql_num_rows($result);
?>

<table>

<?PHP
while($i < $num)
{

echo '<TD valign="middle" align="left"><FONT size="'.$preview_news_text_fontsize.'" face="'.$output_fontface.'"><A HREF=tuotetiedot.php?uid=';
echo mysql_result($result,$i,"uid");
echo ">";
echo mysql_result($result,$i,"table_nimi");
echo "</FONT></TD>";
$i++;
};
?>

</table>

[leatherback]

Hi,

Something like this should work:

$result = mysql_query ("select * from kuvasto where table_categoria = 'miesten_casual'"); 

while $row =@ mysql_fetch_array( $result  )
  {

$table body = "<table>";

$table body .=

"
<tr> 
<td>$row[product]</td>
</tr> 
";

}

$table body .= "</table>";

In html:

<? echo $table body ?>

[kapseli]

I tried this

<?php

for ($i=1;$i<$num;$i+3) {
   echo "<TR>";

for ($a=0;$a<3;$a++) {

       $riviarvo = $i+$a;
  echo '<TD valign="middle" align="left"><FONT
 size="'.$preview_news_text_fontsize.'" face="'.$output_fontface.'"><A HREF=tuotetiedot.php?uid='; 
      echo mysql_result($result,$riviarvo,"uid");
      echo ">"; 
      echo mysql_result($result,$riviarvo,"table_nimi"); 
      echo "</FONT></TD>"; 
      }
   echo "</TR>";
   }
?>

but there is something wrong..... it loops like this

product1 product2 product3
product1 product2 product3
product1 product2 product3
product1 product2 product3
....