[RESOLVED] Rearranging Table Rows

[user55]

Hi,

How can I rearrange my table rows to display like the following:

I would like it to display like this:

first row results
first row results
first row results

second row results
second row results
second row results

Right now it alternates and it displays like this:

first row results
second row results
first row results

echo "<table cellpadding=\'2\' cellspacing=\'0\'>";
echo "<tr>";
echo "<td class=\"th\" >COL1</td>";
echo "<td class=\"th\" >COL2</td>";
echo "<td class=\"th\" >COL3</td>";
echo "</tr>";

 if($result && mysql_num_rows($result) > 0)
{    while($row = mysql_fetch_array($result))        

   {
   echo ('<tr>');//first row
      echo ('<td>'.$row[1].'</td>');
      echo ('<td>'.$row[2].'</td>');
      echo ('<td>'.$row[3].'</td>');
    echo ('</tr>');

echo ('<tr>');//second row
  echo ('<td>'.$row[4].'</td>');
  echo ('<td>'.$row[5].'</td>');
  echo ('<td>'.$row[6].'</td>');
echo ('</tr>');
   } // end while
} // end if results
echo ('</tr></table>');

[tekky]

Your example isnt very clear in getting your point across... maybe providing how you expect the data to look in the returned result set/$row vars... then we can actually see what you are starting with data wise and can get an idea of how to take you from point A to point B.

[user55]

Hi,

The code displays the results with table row2 alternating every time after table row1. For example:

table row1: A | B | C
table row2: 1 | 2 | 3
table row1: D | E | F
table row2: 4 | 5 | 6
table row1: G | H | I
table row2: 7 | 8 | 9

I want to display all of the results in table row1 first then display all the results in table row 2. For example:

table row1: A | B | C
table row1: D | E | F
table row1: G | H | I

table row2: 1 | 2 | 3
table row2: 4 | 5 | 6
table row2: 7 | 8 | 9

Hope this makes sense.

I was told to create an array in my fetch loop, then build another couple of loops to create the html markup for it to work.

Here is my new code below, but I get the following error on both of the "foreach" lines:

"Warning: Invalid argument supplied for foreach()"

What am I doing wrong?

echo "<table cellpadding=\'2\' cellspacing=\'0\'>";
echo "<tr>";
echo "<td class=\"th\" >COL1</td>";
echo "<td class=\"th\" >COL2</td>";
echo "<td class=\"th\" >COL3</td>";
echo "</tr>";

if($result && mysql_num_rows($result) > 0)
{    for ($i = 0; $i < mysql_num_rows; $i++) {
    $resultArray[$i] = mysql_fetch_array($result);
}

foreach ($resultArray as $val) {
   echo ('<tr>');//first row
      echo ('<td>'.$val[1].'</td>');
      echo ('<td>'.$val[2].'</td>');
      echo ('<td>'.$val[3].'</td>');
    echo ('</tr>');
}

foreach ($resultArray as $val) {
    echo ('<tr>');//second row
      echo ('<td>'.$val[4].'</td>');
      echo ('<td>'.$val[5].'</td>');
      echo ('<td>'.$val[6].'</td>');
    echo ('</tr>');
}

}
echo ('</table>');

[tekky]

This might work... still not sure you gave enough info on your data...
are you getting a single row from a database or is row1/row2 2 seperate results in the result array?

I've done this so far, but I dont have enough data to simulate what you are getting back reliably to test it...

<?php
echo "<table cellpadding=\'2\' cellspacing=\'0\'>"; 
echo "<tr>"; 
echo "<td class=\"th\" >COL1</td>"; 
echo "<td class=\"th\" >COL2</td>"; 
echo "<td class=\"th\" >COL3</td>"; 
echo "</tr>"; 

if($result && mysql_num_rows($result) > 0) {
	while($row = mysql_fetch_array($result)) { 
		$count = count($row);
		echo ('<tr>');//first row 
		for($i=0;$i<$count;$i++) {
			echo ('<td>'.$row[$i].'</td>'); 
		} //end for
		echo ('</tr>'); 
	} // end while 
} // end if results 
echo ('</table>'); 
?>

[user55]

Hi,

Thanks for the reply. I have the following code and now it brings up the table separately like I want them to. The first table display several results which is fine. But, the second table row repeats the same result multiple times. There is only one result in the second table row and should only appear once.

Does the second table row need its own mysql query?

Is there a way for me to make the second table row result only appear once?

if($result && mysql_num_rows($result) > 0)
{    for ($i = 0; $i < mysql_num_rows($result); $i++) {
    $resultArray[$i] = mysql_fetch_array($result);
}

foreach ($resultArray as $val) {
   echo ('<tr>');//first row
      echo ('<td>'.$val[1].'</td>');
      echo ('<td>'.$val[2].'</td>');
      echo ('<td>'.$val[3].'</td>');
    echo ('</tr>');
}

foreach ($resultArray as $val) {
    echo ('<tr>');//second row
      echo ('<td>'.$val[4].'</td>');
      echo ('<td>'.$val[5].'</td>');
      echo ('<td>'.$val[6].'</td>');
    echo ('</tr>');
}

} // end if results
echo ('</table>');