Multiple Columns Output

[kamy99]

Hi all:

I need to output the result of query in a three-columned table. How would I achieve this?

FYI, my query is retrieving the correct data, except everything come out in a one-columned table.

My simplified code is:

<?
db_connect();
$getCats=mysql_query("Select * from Categories '");
while ($i=mysql_fetch_array($getCats))
{

echo $i[1];

}
?>    

thanx

[jeremuck]

You need TWO loops. One loop represents each row. The inside loop represents each column.
For each provides an easy way to loop through the columns for each result.

I do it like this

<?
db_connect();
$getCats=mysql_query("Select * from Categories '");

//assuming it's done correctly, print the table headers
print "<table><tr>\n<th>col1</th><th>col2</th><th>col3</th>\n</tr>\n";

// now we loop through all the results. each record will be one row
while ($row=mysql_fetch_array($getCats, MYSQL_ASSOC))
{
  print "<tr>\n";

//now we do an inner loop for each column
  foreach($row as $value)
  {
     print "\t<td>" . $value . "</td>\n";
  }

  print "</tr>\n";

}

print "</table>";
?>    

[kamy99]

Perhaps I didn't explain my goal too clearly. 😕

Let's say I have 12 items in my category, I'd like the output to be in a 3 column by 4 rows table.
Obviously, the number of rows would change with addition/delition of items, but I want the table to be in 3 columns.

I do this easily enough in Cold Fusion, but somehow I'm struggling with it in PHP......

[jeremuck]

oh

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

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

}

that will print everything in one results array into a 3 col table.

if you are getting something from the db where there is only one item per result, and you want to spit it out into a 3 col table:

//FLOW: 
//Query db
//Find out how many results were returned.
//Loop for number of results returned.
// Inner loop to 3

$totalRows = mysql_num_rows($results);
for($rowWalker = 0; $rowWalker < $totalRows; ++$rowWalker)
{
  print "<tr>\n";
  for($walker = 0; $walker < 3; ++$walker)
  {
    if($value = mysql_result($result, $rowWalker, "fieldname"))
    {
      print "\t<td>" . $value . "</td>\n";
    }
  }
  print "</tr>\n";
}

supposedly mysql_result is not a great function to use.
Does this do what you want?
If so, this was an interesting problem. Not very common I think. This will print a single value from each row returned from a query in a 3 col table.

[kamy99]

Thanx, that solved the issue.