[Resolved] For statement needed....

[patsfans]

My question is I'm trying to output table rows with three items in each row instead of outputting items row by row. I know I need a "for" statement to output this, I'm just not sure how to put that together.

I know this is easy, so I'm guessing one of you guys in here can help with this.

Here's the code I'm using:

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

$name= ($rowh['title']);
$description = ($rowh['author']);
$price = ($rowh['date']);

$item .= "<td>$name<p>$description<p>$price</td>";

Thanks in advance!

Ian

[BlueMeteor]

???????????

$name= ($rowh['title']);

$rowh?you should use.....

$name= ($row['title']);

[cgraz]

if you want to display like this

A B C
D E F
G H I

instead of

A
B
C
D
E
F
G
H
I

This code will do what you want

$i = 1; 
$cols = 3; 

echo "<table border='1' width='100%'><tr>";

while ($row=mysql_fetch_array($result)) {
    if ($i > $cols) {
       echo "</tr><tr>";
       echo "<td>" . $row["name"] . "<p>" . $row["author"] . "</p><p>" . $row["date"] . "</p></td>";
       $i = 2;
    } else {
       echo "<td>" . $row["name"] . "<p>" . $row["author"] . "</p><p>" . $row["date"] . "</p></td>";
       $i++;
    }
}
echo "</table>";

Cgraz

[TTT]

also you can use fmod