[Resolved] Displaying rows in table question

[jamesflynn]

This is probably a pretty easy one. But if I have page where im reading a row
while ($row = mysql_fetch_array($result))
and then echoing the output
echo ("".($row["item"])." whataver content here");
and thats working perfectly but instead of just having one long row of items I'm gonna break them into 3 columns.

So it will be:
While $row

echo row1 echo row2 echo row3

So whats the code to call the record for the second or third rows. Then I'm assuming once it formatted with that basic row inside the table it will automatically loop properly pulling the new records with same format?

Thanks alot for any help,
James Flynn

[bastien]

$x=1; //counter
while ($rows=mysql_fetch-array($result)){

if ($x==1){
    echo "<tr>";
    $x++;

}
echo  "<td>".$rows['value']."</td>";
$x++;       //increase counter

if ($x==3){
   echo "</tr>"; 
   $x=1;
}

}//end while

[jamesflynn]

Thanks alot Bastien.

I think that did it.

James Flynn