Multiple Columns Output

[kamy99]

Hi :

I'd like to display the results of my query in a 3 columned table.
For example:
If I have 15 products, I get a 3 column table with 5 rows. So the first cell has the first item, the second cell the second product....

The code I have so far is below, but it's not working the way I need it.

Any ideas?

thanx
Kamy99

$getCats=mysql_query("Select CatName from Categories ");

$totalRows = mysql_num_rows($getCats);
echo "<table>";
while ($row=mysql_fetch_array($getCats)){


foreach($row as $value)
{
  print "<tr>\n";

  for($walker = 0; $walker < 3; ++$walker)
  {
    print "<td>" . $value . "</td>\n";
  }
  print "</tr>\n";

}}
echo "</table>";

[tomhath]

First of all, "not working the way I need it" doesn't give very much information about what is is doing.

Second, your inner loop never changes $value. But you don't need an inner loop anyway:

foreach($row as $value)
{
  print "<tr><td>" . $row[0] . "</td><td>" . $row[1] . "</td><td>" . $row[2] . "</td></tr>\n";
}

[tomhath]

Opps, didn't whack enough of your code. You don't need either for loop:

while ($row=mysql_fetch_array($getCats) ){
  print "<tr><td>" . $row[0] . "</td><td>" . $row[1] . "</td><td>" . $row[2] . "</td></tr>\n";
}

[barand]

echo "<table>";
$count=0;
while (list($value)=mysql_fetch_row($getCats)){

  if ($count == 0) print "<tr>\n";
  $count++;	
  print "<td>" . $value . "</td>\n";
  if ($count==3) {
  	print "</tr>\n";
	$count=0;
	}
}
if ($count!= 0) print "</tr>\n";
echo "</table>";

hth

[kamy99]

You're right, i didn't explain it clearly enough. Here's another go:

Supposed the table was static:

I want the output to be like this:

<table>
<tr><td>Item 1</td><td>Item 2</td><td>Item3</td></tr>
<tr><td>Item 4</td><td>Item 5</td><td>Item6</td></tr>
<tr><td>Item 7</td><td>Item 8</td><td>Item9</td></tr>
</table>

Right now my original code results in a table like this:

<table>
<tr><td>Item 1</td><td>Item 1</td><td>Item1</td></tr>
<tr><td>Item 2</td><td>Item 2</td><td>Item2</td></tr>
<tr><td>Item 3</td><td>Item 3</td><td>Item3</td></tr>
:
:
<tr><td>Item 9</td><td>Item 9</td><td>Item9</td></tr>
</table>

That's how I don't want it!

Secondly, the value should always remain $i[0], because that's the value I want in each cell.

I do this all the time in Cold Fusion, but for some reason get stuck on the php version !

Did this help?

Thanx

[kamy99]

Your last posting did it .

I appreciate it.

Thanx
kamy99

[barand]

If it's a static table why bother with PHP - just create a static HTML page.