Multiline While loop

[Napster]

I am making an inventory for items on my game site. Now I want three items per line and I am using a while loop. The thing is, I can only get 1 item per line and like I said I want 3 per line. How would I do this. So far my code is...

$s = mysql_query("SELECT * FROM inventory, items WHERE username='$username' AND inventory.iid=items.id") or die(mysql_error());

<table width=300>";

while ($i = mysql_fetch_array($s)) {

echo "<tr>
<td width=100>
<center>
<img src=$i[image] alt=$i[Name] width=60 height=60>
<br>
<b>Name:</b> $i[Name]
</td>
<td width=100>
<center>
<img src=$i[image] alt=$i[Name] width=60 height=60>
<br>
<b>Name:</b> $i[Name]
</td>
<td width=100>
<center>
<img src=$i[image] alt=$i[Name] width=60 height=60>
<br>
<b>Name:</b> $i[Name]
</td>
</tr>";

}

echo "</table>";

Thank you in advance. Any help would be appreciated.

[ScubaDvr2]

easy

$i = 0;
while ($blad != 10)
{
     if ($i == 0)
     {
           echo "<tr>";
     }
     elseif ($i % 3 == 0)
     {
          echo "</tr>";
          echo "<tr>";
     }
     echo "Table cells etc";
     $i++;
}

I think something like that would do the trick. use Modulus to determine if $i is at each 3 interval and only THEN would you want to create a new row

[Napster]

Ok thank you, but I have no idea how to use that. I did this once about a year ago but I forgot how to do it.

[ScubaDvr2]

Okay look.. let me rewrite your code for you I guess

echo "<table width=300>";
$i = 0;
while ($i = mysql_fetch_assoc($s)) { 

if ($i == 0)
{
   echo "<tr>";
}
elseif ($i % 3 == 0)
{
   echo "</tr>";
   echo "<tr>";
}

echo "
<td width=100> 
<center> 
<img src={$i['image']} alt={$i['Name']} width=60 height=60> 
<br> 
<b>Name:</b> {$i['Name']} 
</td>"; 
$i++;

} 

echo "</tr>";
echo "</table>";

I think that should work for you.

[Napster]

Wow that is awsome, thank you so much.